Don,
afaik: to speed up your macro
EITHER use:
worksheets(x) .DisplayAutomaticPageBreaks = False
it's a hidden property of the worksheet object
(only shows up if hidden properties are displayed in the object browser)
you dont need to repeat that..
OR use:
worksheets(x) .DisplayPageBreaks=false
you DO need to repeat that line after each print or printpreview
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
Don Lloyd wrote :
Hi,
I have a workbook which contains some fairly complex subs but they
run fast enough for normal needs. However, after running a small sub
that just sets the PrintArea and does a PrintPreview , code execution
becomes exceeedingly slow.
Any ideas ?
Thanks,
Don