P
Paul Black
Hi everyone,
How can I count the number of rows with data in from "B4" down to
whatever. I would like it based on this please :-
Worksheets("A").Range("B4")
I have tried :-
Worksheets("Wheel").Range("B4").UsedRange.Rows.Count
Worksheets("Wheel").Range("B4","B4" & .End(xlDown), Rows.Count)
Worksheets("Wheel").Range("B4","B" & .End(xlDown), Rows.Count)
Worksheets("Wheel").Range("B4:B" & .End(xlDown), Rows.Count)
etc
Thanks in Advance.
All the Best.
Paul
How can I count the number of rows with data in from "B4" down to
whatever. I would like it based on this please :-
Worksheets("A").Range("B4")
I have tried :-
Worksheets("Wheel").Range("B4").UsedRange.Rows.Count
Worksheets("Wheel").Range("B4","B4" & .End(xlDown), Rows.Count)
Worksheets("Wheel").Range("B4","B" & .End(xlDown), Rows.Count)
Worksheets("Wheel").Range("B4:B" & .End(xlDown), Rows.Count)
etc
Thanks in Advance.
All the Best.
Paul