PDA

View Full Version : Checking if range of cells=VbNullstring


Rasm
02-02-2012, 06:29 AM
I am looking for VBA code - to search a Range of cells - I want to make sure all cells in the specified Range are empty - any suggestions
Admin
02-03-2012, 06:14 AM
Hi

something like


msgbox selection.cells.count=worksheetfunction.counta(sel ection)
Rasm
02-03-2012, 07:24 AM
Ahhh - never used .Counta - cool Thanks