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

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

Thanks a million,

Is it necessary to set both types of PageBreaks to false?

Don

"keepITcool" <xrrcvgpbby@puryyb.ay> wrote in message
news:xn0e5abdfliz15g003keepitcoolnl@news.microsoft.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

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" <xrrcvgpbby@puryyb.ay> wrote in message
> news:xn0e5abdfliz15g003keepitcoolnl@news.microsoft.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

Thanks again,

I just added
Activesheet.DisplayPageBreaks = False
to the end of the print code and it worked fine.

Don

"keepITcool" <xrrcvgpbby@puryyb.ay> wrote in message
news:xn0e5aclnlklude006keepitcoolnl@news.microsoft.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" <xrrcvgpbby@puryyb.ay> wrote in message
>> news:xn0e5abdfliz15g003keepitcoolnl@news.microsoft.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