Printing selected data using the offest command

[BROWNO1234]

Hi,
I have the attached workbook where i would like to print the data on the 'Skorby comm'tab. Currently the data goes from upto A189-S189,sometimes this coud be less data and other times could be more.
I undestand there is an offset command to print selected data but i am unsure how i do this,i would then like to set up a Macro to print this workbook out...Your help again would be appreciated...

[carsto]

Have you tried Selection.PrintOut instead of ActiveWindow.PrintOut ?

[BROWNO1234]

how do i use this? not sure what to do?
Thanks..

[BROWNO1234]

Hi,
I have tried this but it prints out the data i want plus blank sheets that i dont want...(the data can always change from day to day so when cells have data in them i need this printing off....) please help

Please Login or Register  to view this content.

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

[BROWNO1234]

this is now solved

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save