gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,347
- Office Version
- 365
- Platform
- Windows
I have this code that works very well if there is only one table on the sheet.
How do I get this to work for just one of the tables?
Table Name: SelectedPartsValidation
Thanks for the help
How do I get this to work for just one of the tables?
Table Name: SelectedPartsValidation
Code:
Sub RefreshStep2()
Sheets("Step 2").Select
With ThisWorkbook
Sheets("Step 2").ListObjects(1).QueryTable.Refresh BackgroundQuery:=False
End With
End Sub