Print range macro

[nc]

Hi

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

Thanks.

 

[Bob Phillips]

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]

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)





.

 

[Bob Phillips]

ActiveSheet.PrintOut
--

HTH

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