Page Setup functions very slow in VBA earlier thread
 

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

Page Setup functions very slow in VBA earlier thread
 

Ok, found my answer:

pscale = "{1,4}"

Jeff