Thread: how do i make a macro that will select all those cells that are empty
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default 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
|


Reply With QuoteReply With Quote