return back to current page after routine

[jackf-nc]

I wrote my first routine from tips I learned from here. After a couple of hours getting all good. I am hoping you can assist with what I am trying to do right before the end sub.

Routine (macro) runs across 2 sheets, all is fine. Routine doesn't select any cells on either page.

What I need is to have page activated and cell A74 selected, depending on what page the routine is run from.

For ex. if routine is called from sheet 1 - obviously the cursor is still on sheet1 - I need it to return to sheet 1 a74 else return to sheet2 a74 if routine ran from there..

Any ideas?


Thanks guys, you are the best!
Jack

[teylyn]

Please don't post the same question into different forum areas. I've answered your other question.

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.