How to Insert Column Headers and Clean up code

**whattodo** · 02-25-2018, 01:11 AM

Hi! Can you help me streamline/ clean up this code? It takes a while for it to run.

Thank you very much!

Please Login or Register  to view this content.

**kev_** · 02-25-2018, 10:25 AM

Deleted by kev - I got distracted and amended the wrong bit of code

**kev_** · 02-25-2018, 10:48 AM

Instead of:

Please Login or Register  to view this content.

Avoid looping with:

Please Login or Register  to view this content.

Same applies to other loop

Just like disabling screen updating, it may also help to set calculation to manual with:

Please Login or Register  to view this content.

And resetting things afterwards with:

Please Login or Register  to view this content.

Re: How to Insert Column Headers and Clean up code