Print area/range

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi. I have a macro that takes a large chunk of data, sorts it, and then
deletes about 2/3rds of the rows. When I go to print the remaining data, it
still assumes that I want to print all of the rows -- even the empty rows.
How do I tell Excel that there is no information below the last row?

Thanks,
Mike.
.

Quantcast