Andy_

Try this....

Select the range of values
<edit<find
Find what: *.*
Click the [Options] button
Look in: Values
Click the [Find All] button

(That will DISPLAY a list of all matching cells...ONE of them will be
selected)

Press Ctrl+A (that will SELECT all of the matching cells)

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=545084