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