Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Print area/range
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. |
#2
|
|||
|
|||
One way; after your Marco is finished, redefine your Print Area.
HTH |
#3
|
|||
|
|||
Maybe resetting that last used cell would fix it, too.
See Debra Dalgleish's site for some ways to do this: http://www.contextures.com/xlfaqApp.html#Unused Mike D. wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
Excel 2002 Will Not Print Text Boxes | Excel Discussion (Misc queries) | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) |