go 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]

At the beginning of the macro, write the active sheet's name into a varable, then use that variable to activate the correct sheet at the end of the routine. Like this:

Please Login or Register  to view this content.

Let me know if that works for you.

cheers, teylyn

[jackf-nc]

PERFECT Teylyn....Worked beautifully!