Printing only a selected area
 

I cant figure out how to print just the selected area in a spread sheet.
The macro I recorded doesnt take into account that I am checking
"Selected Area". Thanks!


--
McManCSU
------------------------------------------------------------------------
McManCSU's Profile: http://www.excelforum.com/member.php...o&userid=24379
View this thread: http://www.excelforum.com/showthread...hreadid=386258

Printing only a selected area
 

"McManCSU" wrote in
message ...
I cant figure out how to print just the selected area in a spread sheet.
The macro I recorded doesnt take into account that I am checking
"Selected Area". Thanks!

Try:

Selection.PrintOut

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm