| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to select cells with values only (not empty ones)?
Basically I am trying to fix a macro of mine, I have it selecting the entire
workbook and pasting the content into a new workbook for editing, however it is bringing about 50,000 ROWS with it, making a big file with alot of empty space, how can I get my macro to just select the cells with content so that I do not paste all the empty rows. Or perhaps a solution to select all the empty rows so I can delete them, either way will work. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to select cells with values only (not empty ones)?
Hi Nick
Check out this site http://www.contextures.com/xlfaqApp.html#Unused -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Nick" wrote in message ... Basically I am trying to fix a macro of mine, I have it selecting the entire workbook and pasting the content into a new workbook for editing, however it is bringing about 50,000 ROWS with it, making a big file with alot of empty space, how can I get my macro to just select the cells with content so that I do not paste all the empty rows. Or perhaps a solution to select all the empty rows so I can delete them, either way will work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save trailing empty cells in a tab delimited text file | Excel Discussion (Misc queries) | |||
| reset values in select cells | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
Linear Mode
