Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counta in vba
I have been trying to assign a value to x derived from the counta function.
I have tried: dim x as integer x = Application.CountA("A:A") Range("b2").Value = x but it seems to perpetually report the value of 1. Appreciate any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
counta in vba
Use this lawlera
x = Application.CountA(Range("A:A")) -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "lawlera" wrote in message ... I have been trying to assign a value to x derived from the counta function. I have tried: dim x as integer x = Application.CountA("A:A") Range("b2").Value = x but it seems to perpetually report the value of 1. Appreciate any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counta | Excel Discussion (Misc queries) | |||
COUNTA? | Excel Worksheet Functions | |||
COUNTA() | Excel Discussion (Misc queries) | |||
COUNTA | Excel Worksheet Functions | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |