Define Print Area using Variables

's Computer Specifications

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

's Computer Specifications

One way:

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

In article
<5ae9b260-3fbe-4caa-bc84-(E-Mail Removed)>,
(E-Mail Removed) 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

's Computer Specifications

On Jan 25, 11:19*pm, JE McGimpsey <jemcgimp...@mvps.org> wrote:
> One way:
>
> * *ActiveSheet.PageSetup.PrintArea = "B" & FinalTableStart & ":T" &
> FinalTableEnd
>
> In article
> <5ae9b260-3fbe-4caa-bc84-32191242a...@d21g2000prf.googlegroups.com>,
>
>
>
> *wfgfree...@gmail.com 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Define print area depending on a cell value	rahmad	Microsoft Excel Discussion	2	23rd Apr 2008 02:42 PM
define a print area and name it based on info in first cell in a row...	Chris Salcedo	Microsoft Excel Programming	3	7th Oct 2005 01:06 AM
Help recording a macro to define print area	John	Microsoft Excel Programming	1	28th Apr 2004 02:45 PM
Macro to define a print area	=?Utf-8?B?SlJvYmVydHM=?=	Microsoft Excel Misc	8	29th Dec 2003 03:10 PM
Highlighting a Block of Cells to Define the Print Area	Mark	Microsoft Excel Programming	8	18th Nov 2003 03:43 AM