If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Santaree" wrote in message
...
Hi,
I am hoping I am not asking a dumb question here! I have a workbook that
has a number of worksheets that all contain external links. I am running
into a problem where if I have to insert data or a new link in a certian
place, my hyperlinks don't seem to want to move with the cell contents.
Maybe if I provided a visual it might help?

Column A Column B Column C
Dog Cat Bird
Dog2 Cat2 Bird2
Dog3 Cat3 Bird3

Each one of the cells is hyperlinked to an external website. If I wanted
to
move "Cat2" and "Cat3" down, to make room for "Cat1", the cell contents
move,
but my hyperlinks won't move! I have cut and pasted, dragged the cells,
anything to get the hyperlink to move with the cell content, but I can't
seem
to get it to move.

I hope I don't look stupid by asking this! The workbook is quite large
and
would be very time consuming to re-do the links everytime I needed to
insert
data. Thanks so much!