counting column elements

[Guest]

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.

 

[Frank Kabel]

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

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

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.