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 |
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 | |
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 |
All times are GMT +1. The time now is 08:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com