See answer to your first posting of this question.

--
Regards,
Tom Ogilvy

"Phil Hageman" wrote in message
...
When a user clicks on cell A1 in Sheet1, they are moved to Sheet2, cell
A1.
What would the code be?

Thanks, Phil