Tim Grollman
Board Regular
- Joined
- Feb 24, 2002
- Messages
- 129
This code will refresh a chart with different data every second, via cell A26. I want it to refresh every 1.5 seconds but I get a type mismatch. Is there a way I can specify fractions of a second?
Sub SlideShow()
For n = 1 To 10
Range("A26").Value = n
Application.Wait (Now + TimeValue("0:00:1"))
Next n
End Sub
Sub SlideShow()
For n = 1 To 10
Range("A26").Value = n
Application.Wait (Now + TimeValue("0:00:1"))
Next n
End Sub