VBA delay code?

FootBallBat

Board Regular
Joined
Jan 26, 2012
Messages
162
The problem I'm having is the vba is trying to process everything at once which is messing it up. I'm positive all the imputed code works.
I need a way to pause the macro for a set time to allow it to finish processing a part of the code before continuing. Application.Wait does not work it does not allow the macro to finish its process it just hangs till the time is up.

So is there anyway to pause the macro without the hang time?
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,098,855
Messages
5,465,094
Members
406,412
Latest member
superjoejoe

This Week's Hot Topics

Top