how to count items in a column

[kualjo]

I need to count the number of items in a column in order to know how many times to run a loop. The file is an output from SAP that never comes out with the same number of entries in the first column. If I can count them, things will go much smoother.
Thanks!

[Bob Phillips]

Try



Application.CountA(Columns("A"))

[kualjo]

That's what I needed! Thanks!