Print some Sheets
 

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

Print some Sheets
 

Hi
why not record a macro while doing this manually :-)

--
Regards
Frank Kabel
Frankfurt, Germany

"A-Design" schrieb im Newsbeitrag
...
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

Print some Sheets
 

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?

--
Return email address is not as DEEP as it appears
"A-Design" wrote in message
...
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

Print some Sheets
 

You are right ,... Thanks for responses


"Jack Schitt" wrote in message
...
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?

--
Return email address is not as DEEP as it appears
"A-Design" wrote in message
...
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