| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define Print Area using Variables
I am trying to define a print area such as :
'ActiveSheet.PageSetup.PrintArea = "$B$36:$S$57" Except the area is not a constant (Columns are constant). I tried this without success: ActiveSheet.PageSetup.PrintArea = "B[" & FinalTableStart & "]:T[" & FinalTableEnd & "]" Is there a way to do this. Frank |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Define Print Area using Variables
One way:
ActiveSheet.PageSetup.PrintArea = "B" & FinalTableStart & ":T" & FinalTableEnd In article , wrote: I am trying to define a print area such as : 'ActiveSheet.PageSetup.PrintArea = "$B$36:$S$57" Except the area is not a constant (Columns are constant). I tried this without success: ActiveSheet.PageSetup.PrintArea = "B[" & FinalTableStart & "]:T[" & FinalTableEnd & "]" Is there a way to do this. Frank |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Define Print Area using Variables
On Jan 25, 11:19*pm, JE McGimpsey wrote:
One way: * *ActiveSheet.PageSetup.PrintArea = "B" & FinalTableStart & ":T" & FinalTableEnd In article , wrote: *I am trying to define a print area such as : *'ActiveSheet.PageSetup.PrintArea = "$B$36:$S$57" Except the area is not a constant (Columns are constant). I tried this without success: ActiveSheet.PageSetup.PrintArea = "B[" & FinalTableStart & "]:T[" & FinalTableEnd & "]" Is there a way to do this. Frank- Hide quoted text - - Show quoted text - Thanks for your help. Frank |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to define a range using variables | Excel Programming | |||
| How to define a range using variables | Excel Programming | |||
| define a print area and name it based on info in first cell in a row... | Excel Programming | |||
| Help recording a macro to define print area | Excel Programming | |||
| Highlighting a Block of Cells to Define the Print Area | Excel Programming | |||
Linear Mode
