27th May 2009, 03:50 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,455
|
|
Excel Help
I am trying to use this code to update my workbook, problem i have is when it updates it moves cells can some one add whats needed so the data is overwriten and no new cells added.
Code:
Public dTime As Date
Sub MyMacro()
dTime = Now + TimeValue("00:05:00")
Application.OnTime dTime, "MyMacro"
BackgroundQuery = True
RefreshStyle = xlOverwriteCells
ActiveWorkbook.RefreshAll
End Sub
|