Don Guillett schreef:
If a vba solution is available do NOT use a worksheet function.

date use dateserial
value use Val("1000") * 3


This one really helped, Don.

Do you know if there's a list somewhere that matches vba and excel
functions.

That would be really helpful.
In stead of calling a worksheetfunction I could simply use a vba function.

Thanks again,

Sybolt