wvanthony

I have created some cell names and would like for them to be a relative reference as opposed to Absolute. In my macro I test for a user selection and then want to jump to that cell name. I use the command Range(txt).Select to jump to that location which works just fine. Here's the problem however. Anytime I insert new data to the worksheet it screws up the reference since it is an absolute reference. How can I create a cell name with a relative as opposed to absolute reference and can I still use the Range(txt).Select to jump to that cell name? Any help you could provide would be greatly appreciated.

Timbo

It can't be done as simply as that, you'll either have to create a function to edit all the range definitions as you add rows, or you'll have to use variables to specifiy the required range using the 'Range(Cells(a,b), Cells(x,y))' form...

wvanthony

Quote:

---

Originally Posted by Timbo
It can't be done as simply as that, you'll either have to create a function to edit all the range definitions as you add rows, or you'll have to use variables to specifiy the required range using the 'Range(Cells(a,b), Cells(x,y))' form...

---

Timbo, thanks for your reply but I'm afraid it went over my head. I'm fairly new at macros. Would it be possible to give me an example or more detailed explanation of what you're talking about. What I'm doing works but is a pain in the butt to have to go back and modify the absolute cell reference for all of the names in the spreadsheet anytime i insert some more data in the spreadsheet.