Page setup problems in VBA

[Thinqer]

Hi All,

I'm trying to copy the page setup (particularly the print area and manual
pagebreaks) from a sheet in one book to a number of sheets in another book.

When I step through the code, it sets the page breaks and other settings
correctly on each sheet, but when I leave the code to run unattended, it
doesn't set the pagebreaks correctly.

Has anybody come across this before? Does anyone know of a solution?

Many thanks,

Thinqer.

 

[Barb Reinhardt]

As I recall, when I did this, I had to toggle to Page Break Preview to get
the page breaks to be seen consistently.