Excel VBA Tips
Search This Blog
Friday, 27 January 2012
TO FIND OUT THE ADDRESS OF BLANK CELLS WITH A MSGBOX
Sub MsgBoxBlankCells()
MsgBox Range("A:E").SpecialCells(xlCellTypeBlanks).Address(0, 0)
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment