check for cell with numeric value
 

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)

check for cell with numeric value
 

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)

check for cell with numeric value
 

Works in my function perfectly

Thanks

Steve

On Wed, 07 Feb 2007 16:37:01 -0000, Tom Ogilvy
wrote:

if isnumeric(cell.value) then