Hi,

I have a large spreadsheet that I would like to print 3 different sheets to
one file (on different sheets) other than the one I am in. Does anyone have
sample code that would do this.

Thanks in advance for any help.

Adella

Hi Adella.

See Ron de Bruin's Print page notes at:

http://www.rondebruin.nl/print.htm

---
Regards,
Norman



"Adella" wrote in message
...
Hi,

I have a large spreadsheet that I would like to print 3 different sheets
to
one file (on different sheets) other than the one I am in. Does anyone
have
sample code that would do this.

Thanks in advance for any help.

Adella

I had looked there and tried:

Sheets("Sheet30").PrintOut

and also

Sheet30.PrintOut(1,16,,,,True,,)

and neither worked?

"Adella" wrote:

Hi,

I have a large spreadsheet that I would like to print 3 different sheets to
one file (on different sheets) other than the one I am in. Does anyone have
sample code that would do this.

Thanks in advance for any help.

Adella

I also tried:

Sheets(Array(Sheet30, Sheet4, Sheet35)).PrintOut PrToFileName:=plan.xls
and received a runtime error 424 Object req?

"Adella" wrote:

I had looked there and tried:

Sheets("Sheet30").PrintOut

and also

Sheet30.PrintOut(1,16,,,,True,,)

and neither worked?

"Adella" wrote:

Hi,

I have a large spreadsheet that I would like to print 3 different sheets to
one file (on different sheets) other than the one I am in. Does anyone have
sample code that would do this.

Thanks in advance for any help.

Adella