First, I want to thank all who responded to my question about how to select a single row from inside an If:Then statement. I appreciate all the suggestions.
Now, I have an entirely different issue. I have cells in a worksheet in a workbook that I need to change the link from one document to another - without doing it one at a time. Scrolling through the worksheet looking for the specific link is a pain and then Editing the link to the new Word file is a real pain.
I was wondering if I could do a find/replace on the document name in multiple links. Lacking that ability, I was wondering if I could list all the links found in the worksheet in one place and then make the change one-by-one.
Thanks,
George Teachman
Now, I have an entirely different issue. I have cells in a worksheet in a workbook that I need to change the link from one document to another - without doing it one at a time. Scrolling through the worksheet looking for the specific link is a pain and then Editing the link to the new Word file is a real pain.
I was wondering if I could do a find/replace on the document name in multiple links. Lacking that ability, I was wondering if I could list all the links found in the worksheet in one place and then make the change one-by-one.
Thanks,
George Teachman