Is there any way to do a replace on the hyperlink addresses w/in cells?
If not, here's a method that I've come up with to edit them, but need the specifics on how to get addresses out and put them into the cells.
1. I have a column of hyperlinks and would like to take the address out of the hyperlink and put them into a column. (Let's say that column "C" was 1000 hyperlinks, I"d like the addresses to go into Column D.
2. I'll then edit the column of addresses. Something like change drive "C" to "M:\NewProject"
3. I'd then like to take the edited addresses and put them back into their original hyperlink.
Can you help me to do #1 and #3. either in Excel or VBA.
If not, here's a method that I've come up with to edit them, but need the specifics on how to get addresses out and put them into the cells.
1. I have a column of hyperlinks and would like to take the address out of the hyperlink and put them into a column. (Let's say that column "C" was 1000 hyperlinks, I"d like the addresses to go into Column D.
2. I'll then edit the column of addresses. Something like change drive "C" to "M:\NewProject"
3. I'd then like to take the edited addresses and put them back into their original hyperlink.
Can you help me to do #1 and #3. either in Excel or VBA.