View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WhytheQ WhytheQ is offline
external usenet poster
 
Posts: 246
Default RefreshAll not quick enough

Help!

I have the following lines of code:

'-----------------------------------------------
ThisWorkbook.RefreshAll

If Range("Input_Date_Flash") <= Range("Access_LatestDate") Then
'blah blah
End If
'-----------------------------------------------

When the workbook refreshes, the range("Access_LatestDate") which
contains a query into an Access file refreshes after the next line of
code executes!

Do I need to add in a line below the line ThisWorkbook.RefreshAll, or
am I just going about this in the wrong way?

Any help greatly appreciated,
Jason.