application worksheetfunctions fail
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 did the job, thanks Don.
Do you know if there's a list somewhere to compare or match vba and
excel functions?
I would prefer using vba functions in stead of calling
application.worksheetfunction.blabla(arguments) all the time.
Save a lot of time and annoyance.
Thanks again.
Sybolt
|