Count Non blank rows in a worksheet or Count Blank rows in a worksheet

‘Count Non Blank rows
r = Application.CountA(Range(“A:A”))

‘Count Blank Rows
r= application.CountBlank(Range(“A:A”)

Leave a Reply