Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Try this:
Blank is an often confusing term with regard to Excel and here I've taken
you literally i.e. nothing on the cell, totally empty. Call with =countblanks() Function countblanks() For x = ActiveCell.Row - 1 To 1 Step -1 If Cells(x, ActiveCell.Column).Formula = vbNullString Then countblanks = countblanks + 1 Else Exit Function End If Next End Function Regards, Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to count#cells w/= value in other column and not count blank c | Excel Worksheet Functions | |||
count blank cells to next value | Excel Discussion (Misc queries) | |||
Count from Blank & Non-Blank Cells | Excel Discussion (Misc queries) | |||
Count the non blank cells | Excel Worksheet Functions | |||
Count the non blank cells | Excel Worksheet Functions |