Ps. Put a button from the Forms toolbar on that worksheet. Make the caption
"Print" and assign that macro to that button.

Brad wrote:

I'm new to Macro's in Excel - but trainable

If cell xx has "AA" - I want to print range1 and range2
If cell xx has "BB" - I want to print range3 and range4
If cell xx has "CC" - I want to print range5 and range6

I would like to have a button that says "print" when the user is ready

How do I do this?

Thanks in advance for helping

--

Dave Peterson