delay macro based on cell value

[mattmc419]

Hey guys,

I've been using the following code to 'pause' a macro:

Application.Wait(Now + TimeValue("00:00:05"))

It takes forever to dig through the code and adjust the values though.

Is there a way to put a value in a cell (say a 5 in A1) to delay 5 seconds?

Thanks!