I'd wonder before starting this whether the ',' isn't actually in the format
and not the value of the cell. If it's in the actual cell data then it will
be a string search
Excel may display 31,205, but it will actually be storing 31025 so looking
for the ',' will not work. Check this out by highlighting the cell and
looking at the value stored in the formula bar
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
"vbastarter" wrote in message
...
Hi I need to find out if a number cell in a cloumn contains "," and the
fire
a msgbox
i need to fire msgbox when i come across cell containg value 31,205
Usually, i would use instr or other string functions but being a number,
thosse strigs are not working .
Any help appreciated.