View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] wfgfreedom@gmail.com is offline
external usenet poster
 
Posts: 28
Default 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