Excel 2003/edit/replace. Under Options/Look In, values is AWOL bu.

cp · Jan 28, 2005

Under Look In options
Find allows for search by formulae OR values OR comments
Replace is restricted to formulaes ONLY
WHY?

Gord Dibben · Jan 28, 2005

cp

Have a look at this google search result. This topic came up a couple days
ago and was addressed by Dave and Myrna.

http://snipurl.com/cd9j

Gord Dibben Excel MVP