counting column elements

D

Daniel Pena

I just imported a text file into Excel. I want to be able to count up the number of elements in Column A1 so I can get an exact count to set up an Array. Can anyone help? Really appreciate the help. Thanks in advance.
 
F

Frank Kabel

Hi Daniel
with the assumption that where are no blank rows in between use
=COUNTA($A:$A)
HTH
Frank
 
T

Tom Ogilvy

msgbox Range(cells(1,1),cells(rows.count,1).End(xlup)).count

--
Regards,
Tom Ogilvy

Daniel Pena said:
I just imported a text file into Excel. I want to be able to count up the
Click to expand...
number of elements in Column A1 so I can get an exact count to set up an
Array. Can anyone help? Really appreciate the help. Thanks in advance.
 
Top