P
pinmaster
Hi, need help with finding and replacing data.
I found this macro on another site
Sub myReplace()
Columns("A:C").Replace What:=Range("E1").Value
Replacement:=Range("E2").Value, LookAt:=xlWhole, SearchOrder:=xlByRows
MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub
Was wondering if anyone could adapt it for my needs. Tried to modify i
myself but don't know anything about VBA.
The data that I want to replace is in a range called "data" (A2:H500
on sheet "datainput"
Replace what ("C5") on "search" sheet
Replacement ("C17") on "search" sheet
column in this case is column 1 of "data"
TIA
Jean-Guy
Canad
I found this macro on another site
Sub myReplace()
Columns("A:C").Replace What:=Range("E1").Value
Replacement:=Range("E2").Value, LookAt:=xlWhole, SearchOrder:=xlByRows
MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub
Was wondering if anyone could adapt it for my needs. Tried to modify i
myself but don't know anything about VBA.
The data that I want to replace is in a range called "data" (A2:H500
on sheet "datainput"
Replace what ("C5") on "search" sheet
Replacement ("C17") on "search" sheet
column in this case is column 1 of "data"
TIA
Jean-Guy
Canad