Focusing on cells without "selecting" them

Hi all,

I am still fairly new to VBA and have in issue I can not solve. Is there a way to set the focus on a range of cells and have a fuction, like sort, happen without actually selecting that range? I want my macro to run in the background without disturbing what I am doing on my other open spreadsheets. Currently if the wookbook is not open, I get an error, also I want the sort to happen without the screen flashing at me. Here is my code:

Please Login or Register  to view this content.

Hope I did that right!

All help is appreciated!

Please Login or Register  to view this content.

That helped out some, taught me a cleaner way to code. I am still getting a "run time error-'9' Script out of range" message when another spreadsheet is open and in use. Any way to fix this problem?

Rep for the cleaner code!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you, I will see if that works for me. I may have been using that command improperly.

Still doesn't seem to work for me. I am showing all of my code for this project to see if it is something else that is causing the problem. The Update_Link module works like it should, and so does the sort module as long as this spreadsheet is the open one. As soon as I open any other spreadsheet it now gives a stop 400 error.

Please Login or Register  to view this content.

I'm completely confused as to why it won't work. All of the code is in the "ThisWorkbook" section in VBA. Do the modules need to be seperated maybe?

Usually I put all macros in Modules, not in ThisWorkbook area.
I put only some event macros in ThisWorkbook area.

Going to mark this one as solved. Since this program is primarily used as a stand alone, I have added a workaround by disabling the macro by user input. Thanks for the help, it is appreciated!