Is there a way to count the used rows in a specified column?
Preferably without using the end(xlUp) or end(xlDown) method.
I was hoping for something like:
MsgBox ActiveSheet.UsedRange.Columns.Count MsgBox ActiveSheet.UsedRange.Rows.Count
Is there a way to count the used rows in a specified column?
Preferably without using the end(xlUp) or end(xlDown) method.
I was hoping for something like:
MsgBox ActiveSheet.UsedRange.Columns.Count MsgBox ActiveSheet.UsedRange.Rows.Count
- I HAVE NO IDEA WHAT I'M DOING