Print Range for Dynamic Print Area

[shellp]

Hello

I am using MS-Excel 2010.

I have a worksheet where rows are visible/hidden based on user selection. I would like to add a "print" button that can be based on this changing size. How do I do that? Thank.

 

[Joe4]

You are welcome.
Glad you got it working.