Hi Experts,
Here is an existing Macro to find and replace links in 100 worksheets.
Sub Replace()
Fnd = Sheets("000.Current month").Cells(10, 2).Value
Rplace = Sheets("000.Current month").Cells(11, 2).Value
For Each sht In Worksheets
If sht.Name <> "000.Current month" Then
sht.Activate
Cells.Replace What:=Fnd, Replacement:=Rplace, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2
End If
Next sht
End Sub
Understandably It takes very long and therefore, hold me to use excel. Can I change macro to work in the background while I am doing other assignments in Excel?
Thanks
Raj
Here is an existing Macro to find and replace links in 100 worksheets.
Sub Replace()
Fnd = Sheets("000.Current month").Cells(10, 2).Value
Rplace = Sheets("000.Current month").Cells(11, 2).Value
For Each sht In Worksheets
If sht.Name <> "000.Current month" Then
sht.Activate
Cells.Replace What:=Fnd, Replacement:=Rplace, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2
End If
Next sht
End Sub
Understandably It takes very long and therefore, hold me to use excel. Can I change macro to work in the background while I am doing other assignments in Excel?
Thanks
Raj