I'm assuming this isn't a very difficult issue to resolve but I am not all that familiar with macros so I've been struggling with it. Basically I have an a macro that updates an external connection then fills down cells adjacent to the connection and also pastes the values. The issue I'm having is that there seems to be a lag in the refresh when I run the macro, so it pastes the formula results before the connection is done refreshing. Basically I just need some sort of code added in that will make sure the connection is done refreshing before it pastes the values. Hopefully that makes sense, and here is the code for reference. Any help would be much appreciated.

Sub AdvancedStats()

ActiveWorkbook.Connections("Advanced Stats").Refresh

With Sheets("2014 Advanced Stats")
.Range("A1:C1").AutoFill Destination:=.Range("A1:C800")
.Range("A2:C800").Value = .Range("A2:C800").Value
End With

End Sub