Re: Find and Replace against set of rules in 2nd table/work***


This is very useful however I'm trying to replace only items in a
certain column.

I thought I'd try to change:


With Worksheets("Sheet1")
Set RngToChange = .Columns(1) ***to .Columns("B")
End With


But that didn't work.

The code, as it is, ends up replacing everything that had a match in
the entire work***. What would I need to change in order to only
find and replace cells in a certain column? Your reply is greatly
appreciated, thanks.


--
mkwan23
------------------------------------------------------------------------
mkwan23's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30210
View this thread: http://www.excelforum.com/showthread.php?threadid=497111

.