Print range macro
 

Hi

How would I print this range,
Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell))
on a single page using landscape format?

Thanks.

Isn't this what a normal print will do anyway? If not, how does it differ
(landscape apart)?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nc" wrote in message
...
Hi

How would I print this range,
Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell))
on a single page using landscape format?

Thanks.

What is the VB coding????


-----Original Message-----
Isn't this what a normal print will do anyway? If not,
how does it differ
(landscape apart)?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nc" wrote in
message
...
Hi

How would I print this range,
Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell))
on a single page using landscape format?

Thanks.



.

ActiveSheet.PrintOut
--

HTH

RP
(remove nothere from the email address if mailing direct)


"nc" wrote in message
...
What is the VB coding????


-----Original Message-----
Isn't this what a normal print will do anyway? If not,
how does it differ
(landscape apart)?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nc" wrote in
message
...
Hi

How would I print this range,
Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell))
on a single page using landscape format?

Thanks.



.