Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
From variable to excel constant
In an excel sheet I'm allowing users to pick from dropdown whether they want
to print in xlPortrait or xlLandscape. It's not feasible to go directly to Page setup because this page setup that we are applying is for another file. However, when I read this choice to a variable and setting pagesetup.orientation to this variable, it doesn't recognize it. This is because xlPortrait should not be a text, but a constant. Is there a formula to convert the string to constant? I must allow user to do the selection in the worksheet. Thanks, Carmen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtract a variable no. of mos. from a constant date? in excel | Excel Discussion (Misc queries) | |||
How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4 | Excel Worksheet Functions | |||
Variable Acting Like a Constant? | Excel Programming | |||
How to declare variable as Excel constant? | Excel Programming | |||
Excel application: Summing several terms (some constant, some variable) | Excel Programming |