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
|