View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Sybmathics Sybmathics is offline
external usenet poster
 
Posts: 9
Default 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