View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Macro to Print specific cells with formatting

In page setup, go to the last tab and unselect gridlines.

Private sub Commandbutton1_Click()
Range("C2:I91").printout
End Sub


or
Private sub Commandbutton1_Click()
activesheet.pagesetup.Printgridlines = False
Range("C2:I91").printout
End Sub

if you want to set it in code.
--
Regards,
Tom Ogilvy


"Clark" wrote:

I want to creat a Macro to Print a specific area, while formatting that
information into a clean and visually appealing appearance.

The area is from C2 to I2 and from rows 2 to 91. When it prints, I just
want to see the information without the gridlines.

Finally, I want the code to run from a Macro button you just "click to print"

Clark