Print some Sheets

[A-Design]

Hi,

I need to write a code that can print some specific range of cells on of
some specific sheets is that possible ?
Can anyone help me to write this code ? Thanks,

Afshin

 

[Frank Kabel]

Hi
why not record a macro while doing this manually

 

[Jack Schitt]

I imagine that you have tried turning on the macro recorder, selecting the
range to be printed, setting the PrintArea to that range, printing it, and
doing the same with the other sheets. In what way is the recorded macro
deficient for your needs?

 

[A-Design]

You are right ,... Thanks for responses

I imagine that you have tried turning on the macro recorder, selecting the
range to be printed, setting the PrintArea to that range, printing it, and
doing the same with the other sheets. In what way is the recorded macro
deficient for your needs?