Print range macro

N

nc

Hi

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

Thanks.
 
B

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)
 
N

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)





.
Click to expand...
 
B

Bob Phillips

ActiveSheet.PrintOut
--

HTH

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