Anyone have a good method for doing a mass change on portions of a hyperlink.
Search and Replace ignores the hyperlinks so that has not worked.
Thanks,
Greg Terry
Anyone have a good method for doing a mass change on portions of a hyperlink.
Search and Replace ignores the hyperlinks so that has not worked.
Thanks,
Greg Terry
Hi Greg
See
http://www.mvps.org/dmcritchie/excel...MakeHyperLinks
for a macro solution
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Greg Terry" <GregTerry@discussions.microsoft.com> wrote in message news:0012531C-F1F1-43B5-A129-A6A6C27CB947@microsoft.com...
> Anyone have a good method for doing a mass change on portions of a hyperlink.
> Search and Replace ignores the hyperlinks so that has not worked.
>
> Thanks,
>
> Greg Terry
More likely the macro in this topic on the same page
http://www.mvps.org/dmcritchie/excel...#FixHyperlinks
"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote
> See
> http://www.mvps.org/dmcritchie/excel...MakeHyperLinks
> for a macro solution
>
> "Greg Terry" <GregTerry@discussions.microsoft.com> wrote ...
> > Anyone have a good method for doing a mass change on portions of a hyperlink.
> > Search and Replace ignores the hyperlinks so that has not worked.
In experimenting I found that if I save out the spreadsheet in .htm format, I
can mass change the hyperlinks. Then open the .htm file and save it back as a
..xls file and the changes are there.
"Greg Terry" wrote:
> Anyone have a good method for doing a mass change on portions of a hyperlink.
> Search and Replace ignores the hyperlinks so that has not worked.
>
> Thanks,
>
> Greg Terry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks