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

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

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