| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i make a macro that will select all those cells that are empty
EditGo ToSpecial, Select Blanks.
If you need this in VBA, record a macro doing the above -- Kind regards, Niek Otten "VB Script for Excel" wrote in message oups.com... |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 | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i make a macro that will select all those cells that are empty
ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlank s).Select
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "VB Script for Excel" wrote in message oups.com... 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 |
| Reply |
| 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 | |||
Linear Mode
