dynamic printing

[BROWNO1234]

Hi
I wonder if somone can help,i am tryin to print out selected data using code.The code below prints of all the pages and i ony want to print the cells that contain data...please help
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

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


Again, the next time I will stop you from posting!