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