Macro Refresh Button: Run-time Error 1004

Hi,

Lucky for me, I have been tasked with 'fixing' a button within a rather large and complex spreadsheet. The button merely refreshes a macro, which pulls data from a specific column in a separate worksheet - I'll call this Column A. The refresh works fine as long as a cell in Column A is selected when I click the button. However, if a cell outside of Column A is selected, and I try to refresh, I receive a VBA run-time error 1004 with the narrative 'Application-defined or object-defined error' (which I presume is indicating a cell within Column A needs to be selected) with the options to End or Debug. As a lot of people use this workbook, keeping a cell in Column A permenantly selected proves a little tricky.

My question is: can I alter the existing macro/create a new macro so that it doesn't matter whether a cell in Column A is selected?

All suggestions welcome.

Thanks for that John - I had been wondering if you could select a range. Where exactly should that code be entered into the macro though? When I select to debug, the following narrative is highlighted:

Please Login or Register  to view this content.

Apologies for such a simple question - I'm a bit of newbie to macros!

Originally Posted by j_henley123

Thanks for that John - I had been wondering if you could select a range. Where exactly should that code be entered into the macro though? When I select to debug, the following narrative is highlighted:

Sheets("SheetX").Select
Selection.QueryTable.Refresh BackgroundQuery:=False

Apologies for such a simple question - I'm a bit of newbie to macros!

J_henley123,

Welcome to the forum.

Please ensure that you use code tags while posting any code in your post, however big or small the code might be. This ensures that your code is easier to read and others can easily use it to test your code.

I have done it for you this time. Please check the forum rules on how to apply them in future.