I notice that whenever I cange a poperty of the PageSetup object the macro gets much slower. I estimate that changing any PageSetup property takes about 1.5 seconds.

Have you also notived this behaviour? Is there an explanation? Is there a way around?

thanks,
Christof

Setting pagesetup in vba IS slow. You don't really need to do it though as once set for a worksheet, it stays that way. There's not really a workaround / speedier way to do it AFAIK

Hi Christof,

I notice that whenever I cange a poperty of the PageSetup object the macro gets much slower. I estimate that changing any PageSetup property takes about 1.5 seconds.

Have you also notived this behaviour? Is there an explanation? Is there a way around?

Many people use the much faster XLM PAGE.SETUP function:

ExecuteExcel4Macro "=PAGE.SETUP(...)"

For details of all the parameters, download the macrofun help file from the MS Web site (search for macrofun or xlmacr8)

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

Thanks for the info

After you use it try

ActiveSheet.DisplayPageBreaks = False

--
Regards,
Tom Ogilvy


"Christof DB" wrote in message
...
I notice that whenever I cange a poperty of the PageSetup object the macro
gets much slower. I estimate that changing any PageSetup property takes
about 1.5 seconds.

Have you also notived this behaviour? Is there an explanation? Is there a
way around?

thanks,
Christof