QueryTable.Refreshing Property

Syntax

expression.Refreshing

expression A variable that represents a QueryTable object.

Remarks

Use the CancelRefresh method to cancel background queries.

Example

This example displays a message box if there is a background query in progress for query table one.

With Worksheets(1).QueryTables(1) If .Refreshing Then MsgBox "Query is currently refreshing: please wait" Else .Refresh BackgroundQuery := False .ResultRange.Select End If End With 

See also:

• QueryTable Object
• QueryTable Object Members