How can I get the .UsedRange count for each column in my sheet?

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?

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?

WORKS Great THANKS


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

for i = 1 to 20
msgbox Columns(i).Address & " - " & application.CountA(Columns(i))
Next

--
Regards,
Tom Ogilvy

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

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?

Bob what you gave me worked great. THANKS it was easier that I even expected
to implement this way.

Good news HotRod.

Regards

Bob


"HotRod" wrote in message
...
Bob what you gave me worked great. THANKS it was easier that I even
expected
to implement this way.