I have the following Macro:

Sub ReplaceHyperlink()
'
' Macro to change Hyperlinks
'
Dim ws As Worksheet
Dim hyp As Hyperlink

For Each ws In ThisWorkbook.Worksheets
For Each hyp In ws.Hyperlinks
hyp.Address =
Replace$(Expression:=hyp.Address, Find:="PATH#1",
Replace:="PATH#2", Compa=vbTextCompare)
Next hyp
Next ws
End Sub


We are changing server names and I got this macro to aid
users in changing some of their hyperlinks. I created it
in Excel 2002 and have a user using Excel 97. They get a
compiling error with the Replace$ function. Is this
function only available in 2002?

Please advise. Thanks for any assistance!