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.