Public Sub ブック全体置換(ByRef ブック As Workbook, ByVal 何を As String, ByVal 何に As String)
Dim シート As Worksheet
For Each シート In ブック.Worksheets
Call シート全体置換(シート, 何を, 何に)
Next
End Sub
Public Sub シート全体置換(ByRef シート As Worksheet, ByVal 何を As String, ByVal 何に As String)
シート.Cells.Select
Selection.Replace What:=何を, Replacement:=何に, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme