Littlemalky
Board Regular
- Joined
- Jan 14, 2011
- Messages
- 223
So in this code, if I specify the range as one cell, even though this is a massive table, it will refresh the entire table? Does it matter with cell I reference, or if it's a header or not? Or is this even the best way to go about it. I read that selecting the sheet and using the ListObject isn't the best way to go about it:
Code:
Worksheets("OKSFinalTableLiveLink").Range("A2").QueryTable.Refresh BackgroundQuery:=False