hi.... i have Macro1 which runs perfectly fine and refreshes the page after every 15 secs.... but i want to run Macro2 after every 3 minutes.....
do i have to make a change in macro1 ??.. or add some code to macro2 ??
here is Macro1
Sub RefreshTime()
Application.ScreenUpdating = False
ActiveWorkbook.RefreshAll
Application.OnTime Now + TimeValue("00:00:15"), "RefreshTime"
Range("f" & Range("f65536").End(xlUp).Offset(1, 0).Row).Value = Format(Now, "hh:mm:ss AM/PM")
Application.ScreenUpdating = True
End Sub
Bookmarks