Thread
:
counta in vba
View Single Post
#
1
Posted to microsoft.public.excel.programming
Lawlera
external usenet poster
Posts: 37
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.
Reply With Quote
Lawlera
View Public Profile
Find all posts by Lawlera