Re: Set print area problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Philip Reece-Heal" <philip.reece-heal@xxxxxxxxxxxxx>
Date: Sat, 14 Jan 2006 20:13:47 -0000

Thanks to you both, that's cracked my problem.

Regards
Philip
"Philip Reece-Heal" <philip.reece-heal@xxxxxxxxxxxxx> wrote in message
news:q9CdnUrSZYKHY1XeRVnysg@xxxxxxxxxxxx
> Trying to automate setting the print area on a *** I use as a template
> and am having problems.
>
> The section of code is:
>
> Set myprint = Range(mytop, mybot)
> myprint.Select
> Active***.PageSetup.PrintArea = myprint
>
> While the required area is selected on screen OK, the last line gives me a
> Run-time error '1004: Unable to set the PrintArea property of the
> PageSetup class.
>
> Have tried some alternatives but I'm stumped.
>
> Any help would be appreciated
>
> Regards
> Philip
>
>

.

References:
- Set print area problem
  - From: Philip Reece-Heal

Prev by Date: Re: Hidden Character Find Macro Help
Next by Date: Re: How to limit 'calculate' (F9) to specific cell, range, sheets, workbooks?
Previous by thread: Re: Set print area problem
Next by thread: Dim an Array with a variable
Index(es):
- Date
- Thread