Define Print Area using Variables

[wfgfreedom]

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

 

[JE McGimpsey]

One way:

ActiveSheet.PageSetup.PrintArea = "B" & FinalTableStart & ":T" &
FinalTableEnd

 

[wfgfreedom]

One way:

   ActiveSheet.PageSetup.PrintArea = "B" & FinalTableStart & ":T" &
FinalTableEnd

 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