| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaArray and Ranges Question
I am trying to replicate the array formul {=((SUMIF(N4:N23,"<0"))/(N36*COUNT(N4:N23)))} in VBA but the range wil change each time the program is run, so I cannot hardcode that part. I there a way to write this to allow for range flexibility or just t solve the formula in the code and return the value straight to th worksheet? Thanks -- akondr ----------------------------------------------------------------------- akondra's Profile: http://www.excelforum.com/member.php...fo&userid=1514 View this thread: http://www.excelforum.com/showthread.php?threadid=26781 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FormulaArray | Excel Worksheet Functions | |||
| VBA and FormulaArray Runtime Err <is not more than 255 Char | Excel Programming | |||
| Converting to R1C1 in FormulaArray | Excel Programming | |||
| FormulaArray..... HELP !!! | Excel Programming | |||
| FormulaArray | Excel Programming | |||
Threaded Mode
