counting column elements

G

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Web Query & Array Questions! 1
Transpose Function not Working with Long Array Elements 4
counting colored cells when merged 2
Asign Array Variant to Column 3
How do I find the number of elements in an Array of Strings? 5
Counting the number of elements within an array that have data 5
Shifting Array Elements 6
Counting the number of nonempty cells 1

Top