Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i make a macro that will select all those cells that are empty
I need to make macro that will select only those cells that have no
values in it. How do i do that? For example: lets say the excel sheet has values in B4 and A9 and A22. How would i make a macro that will select all other cells except those three cells above.? Regrds |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to select cells with values only (not empty ones)? | Excel Discussion (Misc queries) | |||
How to select cells with values only (not empty ones)? | Excel Discussion (Misc queries) | |||
Select variably-sized range which contains empty cells | Excel Programming | |||
macro to colour empty cells (cells not recognized as empty) | Excel Programming | |||
Macro to select non empty rows in a given range | Excel Programming |