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.
|