Thread: .Refresh BackgroundQuery:=False
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Francois via OfficeKB.com Francois via OfficeKB.com is offline
external usenet poster
  
Posts: 109
Default .Refresh BackgroundQuery:=False
I think that you will need to do something like this:-

Sheets("Data").Select
Range("C7").QueryTable.Refresh BackgroundQuery:=False

Ammend Sheet name & Range to your actual needs

--
Message posted via http://www.officekb.com

Reply With QuoteReply With Quote