Re: Page Setup functions very slow in VBA RE: earlier thread

[Jeff]

Hi, I am trying to follow Tom's following advice on this topic and use
the Excel4 macro language to speed up a VBA print routine:

>What does it mean "Set scale to a two-item horizontal array" ?
>pscale = 1,4 OR pscale = (1,4) will not compile.

>1,4)
>isn't an array

>{1,4}
>would be an array

>pscale = {1,4}

{1,4} is horizontal
{1;4} is vertical

I tried entering "pscale = {1,4}" but get a "Compile Error: Invalid
Character" message on this line.
Can anyone see my error?

Thanks,

Jeff

[Jeff]

Ok, found my answer:

pscale = "{1,4}"

Jeff