If you use TOBEOUT, make sure you specify whole cell.
--
Regards,
Tom Ogilvy
"kkknie" wrote in message
...
You'll need to do three find/replaces. Click the box above row one and
to the left of column A to select all cells. Then hit Ctrl-H to open
Find/Replace dialog.
First Find IN and replace with TOBEOUT and replace all.
Next Find OUT and replace with IN and replace all.
Finally, Find TOBEOUT and replace with OUT and replace all.
K
--
kkknie
------------------------------------------------------------------------
kkknie's Profile:
http://www.excelforum.com/member.php...fo&userid=7543
View this thread: http://www.excelforum.com/showthread...hreadid=267298