Hi Guys,
I need a macro that will print a selection Sheet Quality Grid("A1:Q57") in color and landscape mode. Can anyone help out ?
Thanks,
Hi Guys,
I need a macro that will print a selection Sheet Quality Grid("A1:Q57") in color and landscape mode. Can anyone help out ?
Thanks,
Anyone? lol
Try this (Record Macro):
Regards,![]()
Sheets("Quality").Range("A1:Q57").Select With ActiveSheet.PageSetup .Orientation = xlLandscape .BlackAndWhite = False End With ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
tt3
Last edited by tuongtu3; 08-23-2013 at 10:59 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks