View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Glen Mettler[_4_] Glen Mettler[_4_] is offline
external usenet poster
 
Posts: 70
Default How do I print only the cells I need?

If you want to do it from a macro, do this:

'build MyRange

Range(MyRange).Select
Selection.PrintOut Copies:=1, Collate:=True

otherwise, select the cells you want to print with the mouse. Select File -
Print
In the dialog box select "Selection" then print

Glen

"Marie" wrote in message
...
I am using Excel 2003, I would like to print only the names, addresss. Is
it
possible to sellect only what you need and print it, from the cells?