if isnumeric(cell.value) then

--
Regards,
Tom Ogilvy


"SteveW" wrote:


I have a function to append/alter a cell depending on it's contents
Is there an easy way to determine cell has a numeric value rather than text
....cell.Value 0 returns true even if cell has Text in it

--
Steve (3)