Slow VBA Loop Code

**krcaldwell31** · 04-30-2012, 08:13 AM

I have a VBA loop code I wrote to move hourly data to a sheet set up in 5 minute intervals, entering the hourly data every 12 spaces. This code works but it takes >20 minutes to run one column of data. Is there any way to speed it up?

Please Login or Register  to view this content.

**tigertiger** · 04-30-2012, 08:38 AM

Hopes that it may run more quickly

Please Login or Register  to view this content.

**royUK** · 04-30-2012, 08:41 AM

Welcome to the Forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I'll add them this time, but make sure taht you read the Forum Rules

**BarryTSL** · 04-30-2012, 08:44 AM

Have you tried turning the calculation to manual at the start of the code then back to automatic at the end ( Application.Calculation )

**krcaldwell31** · 04-30-2012, 09:13 AM

I tried the above suggested code and it worked perfectly, processing very fast now. Thank-you very much.

**krcaldwell31** · 04-30-2012, 09:14 AM

Ok, my apoligies, I'll remember for next time.

Slow VBA Loop Code

LinkBack

Thread Tools

Rate This Thread

Display

Slow VBA Loop Code

Re: Slow VBA Loop Code

Re: Slow VBA Loop Code

Re: Slow VBA Loop Code

Re: Slow VBA Loop Code

Re: Slow VBA Loop Code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions