Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub terfuge()
- ' todo: Assign keystroke shortcut
- If Application.DisplayAlerts Then
- Application.DisplayAlerts = False
- Else
- Application.DisplayAlerts = True
- End If
- End Sub
- Sub Multi_FindReplace()
- Dim sht As Worksheet
- Dim fndList As Variant
- Dim rplcList As Variant
- Dim x As Long
- fndList = Array("#REF", "PROD DEPTPAPERLESS2016Oct")
- rplcList = Array("Total", "")
- 'Loop through each item in Array lists
- For x = LBound(fndList) To UBound(fndList)
- 'Loop through each worksheet in ActiveWorkbook
- For Each sht In ActiveWorkbook.Worksheets
- sht.Cells.Replace What:=fndList(x), Replacement:=rplcList(x), _
- LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _
- SearchFormat:=False, ReplaceFormat:=False
- Next sht
- Next x
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement