S
Scott
Hello,
I have read about and am experiencing first hand the lag that changing
the page setup on a sheet causes.
My macro processes workbooks that have variable amounts of sheets --
some with 20 or more. Currently I process each sheet individually
(i.e For each sheet in wkbk.Worksheets). Part of that processing is
updating the page setup.
The page setup more than quadruples the time of the macro.
So, my question is: Is it possible to have VBA group all the sheets
and then change the page setup (just once) and have it get applied to
all the sheets? It would seem that changing the page setup once,
instead of 20 or more times, would considerably cut down on the time
the macro is running.
Any insights would be really appreciated.
Thanks,
Scott
I have read about and am experiencing first hand the lag that changing
the page setup on a sheet causes.
My macro processes workbooks that have variable amounts of sheets --
some with 20 or more. Currently I process each sheet individually
(i.e For each sheet in wkbk.Worksheets). Part of that processing is
updating the page setup.
The page setup more than quadruples the time of the macro.
So, my question is: Is it possible to have VBA group all the sheets
and then change the page setup (just once) and have it get applied to
all the sheets? It would seem that changing the page setup once,
instead of 20 or more times, would considerably cut down on the time
the macro is running.
Any insights would be really appreciated.
Thanks,
Scott