Recent content by Statistician

Thanks for replying MajP. That's a great idea using a variant. I'll update my code accordingly. Cheers!

Okay, I managed to solve this one using some similar concepts in other threads. If anyone is interested, I've listed my solution below. The problem was that the query I was using to pull the "input" data for my vba function was making reference to a table where there were some null values in...

Wonder if anyone is able to help please (I have scanned through some threads but cannot find a solution). I have a simple query (using Access 2010) where I've used a vba function to use a date field in the query and return a period value (integer). When I try to enter something like >1 in the...

N1GHTEYES Apologies for lack of detail. I've subsequently found out that I was actually after something called TreeMaps not heat maps. These are available as an addin into Excel and do exactly what I wanted. I will certainly take on board your advice next time I ask for assistance. Cheers.

Does anyone know how to create heat maps in excel? The kind I'm looking at are like those shown in the following link: http://www.digitallook.com/cgi-bin/dlmedia/investing/visual_tools/market_maps?&username=&ac= I want to be able to change the size and colour of the boxes

Thanks anotherhiggins...that advice was spot on and it worked a treat. Apologies again, I will endeavour to try to be more specific and accurate in the future. Your help was much appreciated.

Also, I tried changing the "FormulaR1C1" after the "activecell." to just "Formula" when I identified the mistake but it had no effect.

Apologies for vague description. The macros are not disabled by the way. After attempting to record the macro, excel states it was unable to record the macro. After stopping the recorder, looking at the macro code - it is simply blank. The line of code I am currently trying to use is as...

Hi Thanks for responding. No, there are no quotes in the formula itself, only around the string expression. eg., "=IF(a>b,1,0)" Also, when I attempt to record a macro it falls over and doesn't work. A colleague informed me that the string size was infact restricted to 255...

Hi I'm having problems copying a string variable to a cell formula in excel. The string is over 300 characters long and if I type this directly into a worksheet cell it works fine (i.e., the logic is correct as far as the formula goes). The string is simply a long IF statement. However, when...

Thanks for responding guys. The initial reason why I wanted to do this was because I wanted to output only a subset of the 3-D array to a worksheet. I was looking for a short-cut to something other than looping through (almost a bit like the resize command where you can output a 2-D array in...

Does anyone know how to move data from a 3-dimensional array into a 2-dimensional array using VBA in Excel? I'd like to select one dimension and hold it constant and then simply transfer data relating to the other 2 dimensions across into a new 2-D array. Eg., Array1(Colour,Size,Cost) and...

If you right click on the status bar at the bottom of excel you can use the count, sum, min functions etc... Does anyone know how to customise this so that you can have other excel functions such as StDev? I have searched high and low and cannot find any information on being able to customise...

Hi. Has anyone noticed how MS Solver in Excel 2003 produces different optimised results compared to the one in Excel 2000? Does anyone know what the key changes to the Solver add-in have been between the two versions? I've tried looking on the net but struggling to find any useful...

Hi I am experiencing problems with releasing a reference to access from memory. Basically I open up access from excel using vba code (dao), do some querying and then close the access application using the .quit and set = nothing commands. However, an instance of access remains in memory (as...