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!
In two steps:
Please Login or Register to view this content.
Gary's Student
Jacobshavn
Thank you for the reply. I've tested the code given, but it still jumps back to the previous sheet.
Let me be more precise with my problem. I'm actually jumping between workbooks. Here is a simplified example of my code:
After this last line it still selects "MyRange" in OldBook, instead of the same address in NewBook, even though NewBook is the active book.Please Login or Register to view this content.
The reason I want need to do this is because I need to give the same range name to cell A5 in NewBook. I therefore need to select it using code. Once I'm on it it's easy to name it.
Thank you for your help!
Last edited by dwsteyl; 06-08-2013 at 04:19 PM. Reason: Corrected a typing error ;)
Try the following:
Please Login or Register to view this content.
Thanks - I've tried that.
It's giving an error: Object doesn't support this property or method
Hi
I don't know why, but this works:
Thank you for the suggenstions!Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks