If a vba solution is available do NOT use a worksheet function.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sybmathics" wrote in message
...
Dave Peterson schreef:
VBA has its own version. Look at InStr in VBA's help.



I have no problem with Find.

I have a problem with date or value.

Are there vba alternatives for the excel worksheetfunctions like date or
value


TIA

Sybolt