gimli
06-09-2010, 09:49 AM
Hi yas,
Got some code here. Trying to print SHANNON range A1:43 but that wont print. Sheet AMANDA prints out ok.
Any ideas to fix?
Thanks
Sub TP()
Sheets("SHANNON").Select
Range("A1:H43").Select
Sheets("AMANDA").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub
Got some code here. Trying to print SHANNON range A1:43 but that wont print. Sheet AMANDA prints out ok.
Any ideas to fix?
Thanks
Sub TP()
Sheets("SHANNON").Select
Range("A1:H43").Select
Sheets("AMANDA").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub