Hi,


I have a lot of cells with numbers. Sometimes, Excel interprets these cells
as text. In the debugger, I get this

?Val([gPD]) < Val([gPD_Count])

False

?[gPD] < [gPD_Count]

True



So, If I convert the named cells to values, everything works fine, but not
always if I don't. Thus this means I have to change my code for every named
cell to

Val([Cell]), or is there another way? As I said, I have a lot of named
cells with numbers, and a lot of code to check.



Why does Excel not sea that it's a number? (Sometimes, I pasted a lot of
numbers programmatically in a sheet, and then, Excel misinterprets!)



Thanks

Jos Vens