Hyperlink - linking a cell within a worksheet to another cell within same worksheet

Originally Posted by saf

I have hyperlinks in a large worksheet that link to other cells within the same worksheet. When rows or columns are added to this worksheet the cells that they are supposed to link to do not change, is there a way to make them change?

You can assign Names to cells which you want to link through hyperlinks. Then it will not be affected when you add rows or columns.

see link below for Named ranges or Naming cells.

http://www.contextures.com/xlNames01.html