True, but I am replacing the value in the cell next to the one I
searched for. The value I searched for does not change only the one
next to it. Basically, I have a list of accounts and the account name
is correct but the account number is not. That same account number is
correct for another account so I do not want to do a global search and
replace on that just the one because it would change some values which
are correct. The code snippet here doesn't seem to have a unreasonable
performance hit.

Mike



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/