Hi all,
Hopefully a simple one to resolve.
I have a hidden sheet, SearchData12, and I am using the following to update the date.
ActiveWorkbook.Worksheets("SearchData12").Range("C11").QueryTable.Refresh BackgroundQuery:=False
I use it in exactly the same way in another file and if works fine, but I'm getting this error with this file.
Application-defined or object-defined error
Thanks in advance for your help
Hopefully a simple one to resolve.
I have a hidden sheet, SearchData12, and I am using the following to update the date.
ActiveWorkbook.Worksheets("SearchData12").Range("C11").QueryTable.Refresh BackgroundQuery:=False
I use it in exactly the same way in another file and if works fine, but I'm getting this error with this file.
Application-defined or object-defined error
Thanks in advance for your help