replace information in one column only

Posted by Elaine Clement on January 14, 2002 8:15 AM

I have an excel macro that I need to replace information in column C only. The problem is the information to be replaced periodically shows up in column A, and that is ok, I do not want to replace that information, only when it appears in column C.

Posted by Jacob on January 14, 2002 1:47 PM

Try this

Columns("C:C").Select
Selection.Replace What:="This", Replacement:="That",LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False

Change "This" and "That" to what you want.

HTH

Jacob

Posted by Elaine C on January 15, 2002 7:48 AM