View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default 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