Type mismatch error

Hi Fareed

I have nt used this function, but when using a Worksheet formula in VBA you must use:

WorksheetFormula.EUROCONVERT(1.2, "temp1", "temp2", True, 3)

Dave
OzGrid Business Applications

Thanks Dave, it seems to get rid of the type mismatch error, but now I get a 'Object Required' error.

Do I need to use an object with this function?? If so which type?

Thanks!!

What's the syntax for this function ?

..try

Application.WorksheetFormula.EUROCONVERT(1.2, "temp1", "temp2", True, 3)

Dave

OzGrid Business Applications

Dave,

The syntax for this function on the spreadsheet is 'EUROCONVERT(1.2, "temp1", "temp2", True, 3)'

But the syntax you've given me doesn't work, it keeps on coming up with 'object required' or 'object doesn't support these methodsor properties'.

Thanks!

Fareed, I haven't given you any syntax! I'm asking you that question.

'EUROCONVERT(1.2, "temp1", "temp2", True, 3)'

Is not a syntax! They are the arguments you are trying to pass to the Function. An example of a sytax for, say VLOOKUP would be:

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Dave
OzGrid Business Applications

This is the syntax for the function, I'm sure I'm using the correct variables.

EUROCONVERT(number,source,target,full_precision,triangulation_precision)

thanks!!

Try

test = Application.WorksheetFunction.EUROCONVERT(number,source,target,full_precision,triangulation_precision)

Ivan