Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange Count for each column
How can I get the .UsedRange count for each column in my sheet?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange Count for each column
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange Count for each column
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange Count for each column
WORKS Great THANKS
"HotRod" wrote in message ... How can I get the .UsedRange count for each column in my sheet? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange Count for each column
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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange Count for each column
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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange Count for each column
Bob what you gave me worked great. THANKS it was easier that I even expected
to implement this way. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
UsedRange Count for each column
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Column If Usedrange of Column ISBLANK Follow-up | Excel Discussion (Misc queries) | |||
Hide Column If Usedrange of Column ISBLANK | Excel Discussion (Misc queries) | |||
Real Value of .UsedRange.Rows.Count | Excel Worksheet Functions | |||
Wrong result returned by UsedRange.Rows.Count | Excel Programming | |||
Problem with UsedRange.Rows.Count | Excel Programming |