Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set PageSetup.PrintArea from MS Project
I'm using VBA from MS Project 2003.
I create an Excel sheet, write data to it and all works well. Now, after writing data to it I want to set a printarea and I try the usual with xlsheet '// being the Excelsheet creatd from MS Project with .PageSetup .Orientation = xlLandscape .PrintArea = "$A$3:$N$158" '// Some address end with end with while running it stops at the .Orientation statement with Error 1004 "Unable to set the Orientation property of the PageSetup class" Adding .Activate doesn't make a difference What could cause this problem and how to solve it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
set PageSetup.PrintArea from MS Project
try using the number 2 instead of xlLandscape
"SoftwareTester" wrote: I'm using VBA from MS Project 2003. I create an Excel sheet, write data to it and all works well. Now, after writing data to it I want to set a printarea and I try the usual with xlsheet '// being the Excelsheet creatd from MS Project with .PageSetup .Orientation = xlLandscape .PrintArea = "$A$3:$N$158" '// Some address end with end with while running it stops at the .Orientation statement with Error 1004 "Unable to set the Orientation property of the PageSetup class" Adding .Activate doesn't make a difference What could cause this problem and how to solve it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PrintArea | Excel Programming | |||
ActiveSheet.PageSetup.PrintArea variable ? | Excel Programming | |||
Help - Error: Unable to set the PrintArea property of the PageSetup class | Excel Programming | |||
PrintArea | Excel Programming | |||
PRINTAREA | Excel Programming |