Problem with refreshing a query table

[rizzo93]

I've tried so many variations on this code and still getting an error: "Object doesn't support this property or method."

Sheets("Acknowledgements").ListObject("tblNotAckPrepped_2").QueryTable.Refresh BackgroundQuery:=False

I just want to refresh a query table on a worksheet. The names of the sheet and table are accurate so what am I missing?

 

[John_w]

ListObjects, not ListObject.

 

[rizzo93]

Geez-louise! I hate it when that happens.

Works now. Thanks, John_w!