Macro for printing dynamic range from multiple worksheets

[dube.rajneesh]

Hi All,

Kindly assist me in cracking this:

In the attached excel workbook: I am having 3 sheets of which the Sheet 2 and 3 i.e. LCC and UCC is where the user inputs cells from column B, there is a serial number identifying how many rows have been selected, these details are populated in Sheet 1 i.e. Collection table where i am defining a dynamic range as per the user input.

The concern is that when i am running the macro all 3 sheets are getting print but the dynamic range is not getting picked, hence in this example there should be only one page print for 2nd sheet while 2 are getting printed.

Please resolve. The code being used is as follows: and the mycell range is defined in Collection sheet.

Please Login or Register  to view this content.

Thanks.

[arlu1201]

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.