| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting cells using EVALUATE
I'm trying to calculate and return a count based on a range and am having
trouble getting it right. I am counting retail store numbers that may be typed in the range. I then use the count in other place in my macro. Non-working code: funcRange = "ActiveSheet.Cells(""DX1:IV1"")" funcName = "=COUNTA" funcNameRange = funcName & "(" & funcRange & ")" mStoreCount = Evaluate(funcNameRange) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =EVALUATE("{ to work in a range of cells | Excel Worksheet Functions | |||
| How do I evaluate a row of cells for a character in each cell? | Excel Worksheet Functions | |||
| Function evaluate multiple cells and return 1st one w/a value | Excel Discussion (Misc queries) | |||
| evaluate two cells and calculate based on criteria | Excel Worksheet Functions | |||
| Using AND function to evaluate cells | Excel Worksheet Functions | |||
Threaded Mode
