dynamic printing

[BROWNO1234]

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 ....

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[royUK]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.