Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Speed
Hi,
I have a worksheet with a list of approx. 1,000 rows and 16 columns. A macro is used to run some fairly complex code to arrange the list in different ways. This works fine and takes almost no time. I also have code that sets the print area, depending on the list arrangement, and then prints. This works OK. The problem is that once the print code has been run it takes ages - enough time to take the dog for a walk - for the list handling code to run. Any ideas ? Don |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Speed
yep.
'forces the pagebreaks on a new worksheet ActiveWindow.View = xlPageBreakPreview ActiveWindow.View = xlNormalView 'NOW you can disable the display of the pagebreaks activesheet.DisplayAutomaticPageBreaks = False activesheet.DisplayPageBreaks = False -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Don Lloyd wrote : Hi, I have a worksheet with a list of approx. 1,000 rows and 16 columns. A macro is used to run some fairly complex code to arrange the list in different ways. This works fine and takes almost no time. I also have code that sets the print area, depending on the list arrangement, and then prints. This works OK. The problem is that once the print code has been run it takes ages - enough time to take the dog for a walk - for the list handling code to run. Any ideas ? Don |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Speed
Thanks a million,
Is it necessary to set both types of PageBreaks to false? Don "keepITcool" wrote in message .com... yep. 'forces the pagebreaks on a new worksheet ActiveWindow.View = xlPageBreakPreview ActiveWindow.View = xlNormalView 'NOW you can disable the display of the pagebreaks activesheet.DisplayAutomaticPageBreaks = False activesheet.DisplayPageBreaks = False -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Don Lloyd wrote : Hi, I have a worksheet with a list of approx. 1,000 rows and 16 columns. A macro is used to run some fairly complex code to arrange the list in different ways. This works fine and takes almost no time. I also have code that sets the print area, depending on the list arrangement, and then prints. This works OK. The problem is that once the print code has been run it takes ages - enough time to take the dog for a walk - for the list handling code to run. Any ideas ? Don |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Speed
not sure, wont hurt.
-- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Don Lloyd wrote : Thanks a million, Is it necessary to set both types of PageBreaks to false? Don "keepITcool" wrote in message .com... yep. 'forces the pagebreaks on a new worksheet ActiveWindow.View = xlPageBreakPreview ActiveWindow.View = xlNormalView 'NOW you can disable the display of the pagebreaks activesheet.DisplayAutomaticPageBreaks = False activesheet.DisplayPageBreaks = False -- keepITcool www.XLsupport.com | keepITcool chello nl | amsterdam Don Lloyd wrote : Hi, I have a worksheet with a list of approx. 1,000 rows and 16 columns. A macro is used to run some fairly complex code to arrange the list in different ways. This works fine and takes almost no time. I also have code that sets the print area, depending on the list arrangement, and then prints. This works OK. The problem is that once the print code has been run it takes ages - enough time to take the dog for a walk - for the list handling code to run. Any ideas ? Don |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Speed
Thanks again,
I just added Activesheet.DisplayPageBreaks = False to the end of the print code and it worked fine. Don "keepITcool" wrote in message .com... not sure, wont hurt. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Don Lloyd wrote : Thanks a million, Is it necessary to set both types of PageBreaks to false? Don "keepITcool" wrote in message .com... yep. 'forces the pagebreaks on a new worksheet ActiveWindow.View = xlPageBreakPreview ActiveWindow.View = xlNormalView 'NOW you can disable the display of the pagebreaks activesheet.DisplayAutomaticPageBreaks = False activesheet.DisplayPageBreaks = False -- keepITcool www.XLsupport.com | keepITcool chello nl | amsterdam Don Lloyd wrote : Hi, I have a worksheet with a list of approx. 1,000 rows and 16 columns. A macro is used to run some fairly complex code to arrange the list in different ways. This works fine and takes almost no time. I also have code that sets the print area, depending on the list arrangement, and then prints. This works OK. The problem is that once the print code has been run it takes ages - enough time to take the dog for a walk - for the list handling code to run. Any ideas ? Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speed-up a macro! | Excel Programming | |||
Speed up macro | Excel Discussion (Misc queries) | |||
Using With to speed up macro | Excel Programming | |||
Speed-up macro | Excel Programming | |||
MACRO Speed? | Excel Programming |