sheets

Whitestar · Mar 13th, 2002, 05:26 AM

Right ive given up with working on sheets without selecting them, so now im going to select the sheet, but i need to the vb for how to go back to the previous sheet that you were working on.

Mar 13th, 2002, 05:33 AM

Hi

You could try something like:
Set x = ActiveSheet

Then later you can return to it using:
x.Select

Hope this is what you are after
regards
Derek

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 05:26 AM	#1
Whitestar New Member Join Date: Feb 2002 Location: England Posts: 15	Right ive given up with working on sheets without selecting them, so now im going to select the sheet, but i need to the vb for how to go back to the previous sheet that you were working on.

Mar 13th, 2002, 05:33 AM	#2
Guest Posts: n/a	Hi You could try something like: Set x = ActiveSheet Then later you can return to it using: x.Select Hope this is what you are after regards Derek