excel_user_1966
New Member
- Joined
- Mar 24, 2002
- Messages
- 7
I have:
------------------
Sub CountHowManyRowOfData()
MsgBox ActiveSheet.UsedRange.rows.Count
End Sub
---------------------
to count how many rows have data.
However, I've got formatted cells (with borders, etc) which are being counted in this too.... whilst i only wish to count how many rows from say the range B6 to I2000 are being used WITH DATA IN THEM. I don't want the formatted but technically empty cells in this count. Is there a way to do this?
------------------
Sub CountHowManyRowOfData()
MsgBox ActiveSheet.UsedRange.rows.Count
End Sub
---------------------
to count how many rows have data.
However, I've got formatted cells (with borders, etc) which are being counted in this too.... whilst i only wish to count how many rows from say the range B6 to I2000 are being used WITH DATA IN THEM. I don't want the formatted but technically empty cells in this count. Is there a way to do this?