| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula error
Hi,
While trying to run a macro containing the following code- Range("N1").Formula = CountIf("K" & x, "J" & z - 1, "yes") / CountIf("L" & x, "L" & z - 1, "yes") error appears saying sub ar function not defined can anyone please help me in this... Thanks in advance for your posts jithu |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula error
try:
Range("N1").Formula = "=CountIf(K" & x & ":J" & z - 1 & ",""yes"")/CountIf(L" & x & ":L" & z - 1 & ",""yes"")" "Jithu" wrote: Hi, While trying to run a macro containing the following code- Range("N1").Formula = CountIf("K" & x, "J" & z - 1, "yes") / CountIf("L" & x, "L" & z - 1, "yes") error appears saying sub ar function not defined can anyone please help me in this... Thanks in advance for your posts jithu |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Error | New Users to Excel | |||
| Formula Error | Excel Worksheet Functions | |||
| Error in formula !! and I can't see why | Excel Discussion (Misc queries) | |||
| How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
| formula error | Excel Discussion (Misc queries) | |||
Linear Mode
