Returning to active sheet

[David]

Hi,
I have a series of worksheets which store data on a separate sheet
"Results".
Data from (e.g.) Sheet A is moved to A1 in Results, then a small macro
checks to see if cell contains data and if not moves down to the next empty
cell. When it finds the empty cell it pastes the data.
How do I then move back to Sheet A? I can't use the actual name because the
user may have been on Sheet B, C etc.
Any help gratefully received!

 

[JLGWhiz]

If you are writing the code, you should know the name of sheet A. You would
use the sheet name to return to it. Maybe if you post the code you are
using, a better solution could be offered.

 

[David]

Sorry, perhaps I wasn't clear enough - I used Sheet A as an example as the
user could be coming from any one of a number of sheets and I need to return
to whichever sheet the user was on - hence sheet name cannot be used.

 

[David]

Fixed it - I used the worksheets index number to return to Sheet 1, and made
sure that was the only sheet visible.
Thanks JLGWhiz for your quick reply, by the way.