Replace fuction replacing all instead of selected cells
I have this code in a macro:
Sheets("Sheet 1").Select
For j = 9 To 39
Cells(j, "A").Replace What:="/", Replacement:="¦"
Cells(j, "A").Replace What:="\", Replacement:="|"
Cells(j, "A").Replace What:="[", Replacement:="€¹"
Cells(j, "A").Replace What:="]", Replacement:="ۼ"
Next j
The problem is instead of only looking in cells A9 to A39 in Sheet 1 for
these characters to replace the macro looks in ALL cells in ALL sheets in the
workbook!
Why is this?
Thanks
Clayton
|