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.

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.