Wednesday 4 February 2015

VBA Count Blank in Activesheet Used Range


Sub countBlnk()

 
Dim count As Integer

 

count = Application.WorksheetFunction.CountBlank(ActiveSheet.UsedRange)

 

MsgBox count

 

End Sub

No comments:

Post a Comment