| 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 |
| 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 | |||
Threaded Mode
