Delay = ws.Range(“J22”).Value
^^ Input from Excel Spread Sheet
Excel Cell Input

Application.Wait (Now + TimeValue(“Delay”))

^^ Function I want to use

I have an excel spread sheet and i want manually change the time delay in seconds for the function application “Wait” in seconds from my excel spread sheet. I received an error saying “Type Mismatch”.

How do I adjust the variable formatting ??

Thank You

I tried using different data types