How to set the Activecell of "Sheet2" to Activecell of "Sheet1"

Hi Shawn, I'm pretty sure this can be done, but can I ask what you're trying to do?

Are you selecting a cell on Sheet2, then pressing a commandbutton or running a macro, and all you want it to do is take you to the same cell address on Sheet1?

If so, try:

Please Login or Register  to view this content.

That worked great Paul, thanks! How do I give you credit for the answer?

If I may ask one more kinda related stupid question, how do I directly assign the contents of one cell to another cell (which is the offset of the ActiveCell). In other words, I want to do something like:

Please Login or Register  to view this content.

...would it be as simple as:

Please Login or Register  to view this content.

?

Thanks!
Shawn

You should be able to use:

Please Login or Register  to view this content.

As for giving credit, the thanks is enough. But if you want, you can click the small icon that looks like a scale in one of my posts to add to my reputation.

Cheers!