But that would give you the rows of the largest column, not separate values.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"HotRod" wrote in message
...
I'll give it a shot, I was using Worksheet("something").usedrange.rows and
then rng.count


"Bob Phillips" wrote in message
...
I think you would have to do it separately per column, like

Dim col As Range
For Each col In Columns("A:L")
Debug.Print Cells(Rows.Count, col.Column).End(xlUp).Row
Next col


--

HTH

RP
(remove nothere from the email address if mailing direct)


"HotRod" wrote in message
...
How can I get the .UsedRange count for each column in my sheet?