counting column elements
 

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.

counting column elements
 

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

Daniel Pena wrote:
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.

counting column elements
 

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

--
Regards,
Tom Ogilvy

"Daniel Pena" wrote in message
...
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.