Hi

Let's assume I have Sheet1. On it I've named cell A5 as "MyRange". I want to jump to MyRange using its name, find and put its address (A5) in a variable, and then jump to Sheet2 and select the same cell address (A5) on Sheet2 by using the address assigned to the variable.

I've been at this for an hour or so, but when I use something like ActiveSheet.Cells(MyRange).Select it jumps back to Sheet1(A5) instead of selecting A5 on Sheet2.

Thanks!