This is all related to a pagebreak preview issue I am having problems
with. HOWEVER
I set the PrintArea dynamically based upon a selection copied from
another sheet based upon an Autofilter from the sheet I am copying.
ActiveWorkbook.Names.Add Name:="Print_Area", RefersTo:=Selection
Stepping through everything it is fine.
I then loop through working down the sheet looking for a date and if
I find one I paste some copied formulas into the following two
rows(which may be the messy way, but it works)
Anyway I finally set the starting page all back to normal using a
custom view with some hidden columns and when I return to the page I
was outputting to, the PrintArea is changed by a few rows less (10),
the view has somehow changed to PageBreak view mode but no page breaks
show except around the edges. PageSetup come out set to 1 page wide
and 1 long.
My question is... Does the resulting page derive some page setup
settings from what was copied? Or is that preserved somewhere so I
need to eliminate it first?
This is a rewrite of a 6 year old workbook I am trying to simplify.
Thank You all,
ScottD
"So his thoughts go around in circles
until he forgets the original reason for his curiosity and is simply
lost ... "
"curiosity is insubordination in its purest form." -Nabakov
Bookmarks