Printing only a selected area

[McManCSU]

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!

[Rob Bovey]

"McManCSU" <[email protected]> wrote in
message news:[email protected]...
> 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