Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the Number of Variable Rows
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.Cou nt 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of dates in a row of cel before or after a variable d | Excel Worksheet Functions | |||
Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
count number of rows (variable range) | Excel Programming | |||
change the number of rows to a variable | Excel Programming |