| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Message - Selection contains empty cells
Hi,
I'm looking for a macro which will pop up a message confirming me that my selection contains cells with no formulas & no constants i.e are completely blank. Thxs beforehand |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Message - Selection contains empty cells
One way -
Sub test() Dim x As Long x = Application.CountA(Selection) MsgBox "Non-blank cells : " & x End Sub Regards, Peter T "al007" wrote in message ups.com... Hi, I'm looking for a macro which will pop up a message confirming me that my selection contains cells with no formulas & no constants i.e are completely blank. Thxs beforehand |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Message - Selection contains empty cells
thxs
Peter T wrote: One way - Sub test() Dim x As Long x = Application.CountA(Selection) MsgBox "Non-blank cells : " & x End Sub Regards, Peter T "al007" wrote in message ups.com... Hi, I'm looking for a macro which will pop up a message confirming me that my selection contains cells with no formulas & no constants i.e are completely blank. Thxs beforehand |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding empty selection | Excel Programming | |||
| Test for an empty selection | Excel Programming | |||
| macro to colour empty cells (cells not recognized as empty) | Excel Programming | |||
| List Selection to First Empty Row | Excel Programming | |||
| Selection of non-empty cells | Excel Programming | |||
Linear Mode
