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?
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.Originally Posted by saf
see link below for Named ranges or Naming cells.
http://www.contextures.com/xlNames01.html
starguy
Tahir Aziz
PAKISTAN
https://www.facebook.com/businessexcel
__________________
Forum Rules (read before you post)
Links to the world of Excel
that worked, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks