Hi R,

Did you change:

Selection.PrintOut Copies:=1, Collate:=True

to:

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

as suggested in my follow up post?

With the former, the sheets will be deselected; with the latter, the sheet
selection should be retained.

Indeed, you might care to add a final line:

Sheets(1).Select

to break the multisheet selection, after printing.

---
Regards,
Norman



"rwong" wrote in
message ...

Actually - I deleted the pseudo blank cells to test it out further - and
apparently, right before the print command is issued, the sheets get
unselected, and only the current highlighted cell gets printed...

Further help would be much appreciated.


--
rwong
------------------------------------------------------------------------
rwong's Profile:
http://www.excelforum.com/member.php...o&userid=12735
View this thread: http://www.excelforum.com/showthread...hreadid=390812