Trying to update comment in multiple locations and sheets from one macro

[rocko82]

I have a workbook that I use to pull data from another server that displays data in a color coded "map" of sorts. It does this through comments using dates and times. I have worked it out so that I can pull together everything I need from each sheet individually, and it all works fine for me, but I get complaints from others that they wish it could be simpler. Is there a way that I can run the macro for three of the five sheets at once? I have tried a few things that I have seen through several other threads, but everything just reloads the active sheet.

This is how I run the query.

Please Login or Register  to view this content.

I have tried adding in "For Each sh In Worksheets" and "Next sh" in where I thought appropriate, and this re-ran the macro three times in the active sheet.

Any help is much appreciated.

[Andy Pope]

You need to alter the code so activesheet is replace with relevant sheet reference.
So something like this

Please Login or Register  to view this content.

[rocko82]

I adjusted as follows:

Please Login or Register  to view this content.

This allows for the pull to happen one time in the sheet that I am currently in, but does not follow into the other two sheets. This fixes the problem that I have had with previous attempts of it running multiple times in one sheet, though, so that is progress. lol

[Andy Pope]

If the routine EQCExecuteAllCommands works on the active sheet then you missed out the ws. infront of the Range("A2").activate

[rocko82]

Interesting fix. You are correct on the missing ws. in front of the Range("A2").activate. Oddly, this put me back to running the EQC routine three times on the same sheet, though. I am not sure why, but to fix this I have moved this routine to it's own Sub. It is dirty, but since it would not follow the same path as the comment routine, I am calling each page individually and running the EQC routine from each page. This could be because of a conflict inside the routine itself, maybe? Since it is proprietary and locked up I cannot look at it myself, so I am not going to fret too much. It is working the way, I believe, everyone wants it to work.

I appreciate your time and effort helping me out on this.