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" wrote in message
...
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!