Macro Speed

**learningkid0808** · 05-18-2011, 01:33 PM

Hi All

This is my first macro code, unfortunately it's taking long time to genereate nearely 8 min.

Need help on this

Please Login or Register  to view this content.

**TMS** · 05-18-2011, 03:51 PM

See if this is any quicker:

Please Login or Register  to view this content.

Note: if there are a lot of formulae, it might also help to switch calculation to manual and then back to automatic.

Regards

**learningkid0808** · 05-19-2011, 07:05 AM

Hi TM

Thanks a lot!!!

Its working great, saved a lot of time!!! Can you advise how to handle these type of requests in future.

Regards

**royUK** · 05-19-2011, 07:55 AM

A PvotTable might be a better option

Re: Macro Speed