Excel.QueryTable.AfterRefresh.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
QueryTable.AfterRefresh event (Excel)	vbaxl10.chm519074	vbaxl10.chm519074	Excel.QueryTable.AfterRefresh	91d930e3-4360-4ec2-8772-dcd67c9e8c41	05/03/2019	medium

QueryTable.AfterRefresh event (Excel)

Occurs after a query is completed or canceled.

Syntax

expression.AfterRefresh (Success)

expression A variable that represents a QueryTable object.

Parameters

Name	Required/Optional	Data type	Description
Success	Required	Boolean	True if the query was completed successfully.

Return value

Nothing

Example

This example uses the Success argument to determine which section of code to run.

Private Sub QueryTable_AfterRefresh(Success As Boolean) 
 If Success Then 
 ' Query completed successfully 
 Else 
 ' Query failed or was cancelled 
 End If 
End Sub

[!includeSupport and feedback]