I got this macro in my previous post.

Sub Replace()
Cells.Replace What:="DataA", Replacement:="DataB",
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, ReplaceFormat:=False
End Sub

This will find the DataA value in excel sheet and will replace it by
DataB value.

Now I want to modify it. This should find the combination of values and
replace it. I mean macro should find that if the value of Column C is
DataA1 and value of Column D is DataA2 (same row), then these values
should get replaced by DataB1 and DataB2 respectively.

Reena


--
reena
------------------------------------------------------------------------
reena's Profile: http://www.excelforum.com/member.php...o&userid=30440
View this thread: http://www.excelforum.com/showthread...hreadid=535813