Per the (verbatim) example in VBA help:
ActiveSheet.PageSetup.PrintArea = ActiveCell.CurrentRegion.Address

--
George Nicholson

Remove 'Junk' from return address.


"wammer" wrote in
message ...

What would be the code for setting the print area equal to the currently
selected range on a sheet (i.e. not just e.g. "a1:d4", but something
that changes?


--
wammer
------------------------------------------------------------------------
wammer's Profile:
http://www.excelforum.com/member.php...o&userid=12452
View this thread: http://www.excelforum.com/showthread...hreadid=401350