Printing Ranges

[Foxy Lady]

Hi there,

I need some assistance in printing different ranges on different sheets with one macro.

My first sheet is named Stickfigure Form on this sheet I have named a range "Stickfigureform" of which I need to print 6 copies.

My second sheet is named Impression sheet on this sheet I have named a range "ImpressionSheet" of which I need to print 1 copy.

My macro will be placed on Stickfigure Form. I only need one macro to do this. Please assist

Regards

 

[Tom Urtis]

This sounds like a macro you can produce with the macro recorder.

Try that and see if it does what you want; seems it should, if what you posted is all you need.