Dim Rng As Range
Set Rng = Range("1:1").Find("タイトル")
Rng.EntireColumn.Select
Selection.Replace What:="~?", Replacement:="_"
Selection.Replace What:="/", Replacement:="/"
Selection.Replace What:="[", Replacement:="["
Selection.Replace What:="]", Replacement:="]"
Selection.Replace What:=">", Replacement:=">"
Selection.Replace What:="<", Replacement:="<"
Selection.Replace What:="~*", Replacement:="*"
Selection.Replace What:=":", Replacement:=":"
Selection.Replace What:=";", Replacement:=";"
Selection.Replace What:="\", Replacement:="_"
Selection.Replace What:="""", Replacement:="_"
Selection.Replace What:=vbTab, Replacement:="_"
End Sub
半角を全角にしたりとかいろいろ、、
0 件のコメント:
コメントを投稿
comment Thank you.