Locating cells?

Hi,

I have created a somewhat large Excel program in which I previously had to move cells from one spot to another du to lack of space. In retrospective, this procedure was complicated in the manner that I had previously written down the location of the cells that needed my attention (For example: Once activity three is done, manually modify the value of LW36). Of course, once I had moved a series of cells from one spot of my worksheet to another, LW36 was no longer there. The cell LW36 may have moved to RT156. In short, that made things much more complicated.

Now, I have to create a new chart in which specific cells are clearly indicated. However, I was wondering if Excel had a function that could point out in which cell I could find a specific answer instead of giving me the value of the cell.

FOR EXAMPLE:

I need to manually modify de value of cell LW36.
I have created, in my program, a reference chart that tells me what to do and when to do it.
In that same chart, I refer to cell numbers that need to be changed. For example: Once activity three is done, manually modify the value of LW36.
However, the cell LW36 may eventually be relocated and may become RT156.
Is there a function that allows me to follow a cell and tell me where it is?

Once activity three is done, manually modify the value of... FORMULA THAT GIVES ME THE LOCATION OF A SPECIFIC CELL THAT MAY EVENTUALLY BE MOVED.

Thank you!

Ray

I'll look into it. Thanks!

Originally Posted by WINGSWINTHECUP

However, the cell LW36 may eventually be relocated and may become RT156.com
Is there a function that allows me to follow a cell and tell me where it is

I hate to sound all nerdy and pedantic, but what you're moving isn't actually the cell - it's the function the cell has in the design of your project - not something excel can keep track of.

This is the purpose that named ranges are designed for. So rather than trying to keep track of what you're moving where, it might be better to give names to the affected cell ranges, change references in formulae and code, THEN start to edit the layout of your worksheet by redefining what the named range points to.

You could, technically, use the indirect() function but that would involve a redesign of the project just for the purpose of crafting an interim solution - you might as well go the whole hog in the first place.

Another, albeit crude, approach would be to do a "search and replace" to find references that need changing, but that's problematic because searching for "A1" wouldn't find "$A$1"etc.

Biex's suggestion is a starting point.

Tim

Thank you for the suggestions Tim. It does give me some insight on some options I may consider for future development. However, in this particular situation, it doesn't really help. What I'm trying to achieve is to create a "to do list" in which I will write down:

STEP 3: Go to cell NH145 and manually modify the value of the cell.

Now, in the past, I have needed to relocate some charts in my Excel program (seldomly, but it has happened before). If I do eventually relocate chart "X" in which cell NH145 is located and moved it to cell ZY155, I want the reference of NH145 in my "to do list" to automatically change to ZY155. In short, I need to know where the cell is located in my large Excel program.

This being said, I do appreciate you taking the time to try to help me with my problem. So, many thanks!