I got hundreds of hyperlinks on the active worksheet. All of the hyperlink addresses point to network paths.
Lots of them now have to be changed the following way:
Examples and Requirements:
Only hyperlinks which contain the following substrings are to be worked on: 90-433-22-19, 90-244-19-22, 90-433-22-99
In the above three cases the substring 'bw' at the very end has to be changed to '4c'
In the above example this results in:
All the others have to be left untouched since they do not contain these substrings.
Would be great if somebody could come up with a VBA-solution since I have to change hundreds of these hyperlink addresses. This would save me hours of time.
Help is much appreciated. Thank you very much in advance.