Page setup problem

[Ussiddiqui]

I am doing page setup of some excel sheets generated from Visual Basic
..

I am having problems executing this code

wrkSheet.PageSetup.Orientation = xlLandscape


Control says, Cant assign value to orientation property of pagesetup
class...............

Please help...............

 

[Bob Phillips]

If you are doing it from VB (as against VBA) then the constant xlLandscape
is not known. Try using

wrkSheet.PageSetup.Orientation = 2

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)