Hi,
I have the attached worknook but am struugling..WIth the command below i can print off all worksheets based on the range. That said i want to dynamic print only those cells that have data in them...Skorby comm.xlsm
Sub printall()
'
' printall Macro
' Macro recorded 18/07/2008 by Weeks
'
'
Sheets("Skorby comm").Select
Range("A1:S500").Select
Selection.PrintOut Copies:=1, Collate:=True
End Sub
Just to add the printing needs to be dynamic ....
Bookmarks