Hi,
Good news (of sorts)...
I created a new workbook in XL 2010 (32-bit), added that constant and saved as an xlsm. I then opened it in XL 2007 and the constant was still there. I saved the file in 2007 and then opened it in 2010 again and the constant was still there.
Can you give me a couple more to experiment with to see if I can reproduce the problem? Unfortunately I don't have XL 2010 64-bit so I can't test with that.
|