Update the sql query

I want to create a macro that updates my SQL query in my excel sheet..

I tried recording one, but it says
"Object variable or With block variable not set"

Please Login or Register  to view this content.

Solved just made a refresh all for the entire page instead

Thanks for providing the solution.