I've got a piece of code that reads:
txtPremium = format(curPremium, "$#,##,0")
It runs fine on my home machine (Excel 97) and work machine (Excel 2000) but I've had users complain that they're getting a "compile error" and "can't find project or library" errors. I've only heard of these occurences on Excel 97 SR-2 but don't know that's the cause.
Has anyone run into anything like this?
This message was edited by jjpkraft on 2002-03-25 09:29
txtPremium = format(curPremium, "$#,##,0")
It runs fine on my home machine (Excel 97) and work machine (Excel 2000) but I've had users complain that they're getting a "compile error" and "can't find project or library" errors. I've only heard of these occurences on Excel 97 SR-2 but don't know that's the cause.
Has anyone run into anything like this?
This message was edited by jjpkraft on 2002-03-25 09:29