Problem with format()

[Bleetz]

Hi, I seem to have some trouble with a couple of functions. Speciall
with string functions like

format()
right()
left()
mid()

Whenever I try to use any of this functions I get an error. I tough
that these came embedded with vba in excel.

Do I have to add a reference? maybe an dll?

Any help would be welcomed.

Thank

 

[E_R]

Yes, they are intrinsic... and they work. Post an example of the code
you're using, maybe it's just a syntax issue?

 

[Tom Ogilvy]

after the error go into tools=>References in the VBE and you should see at
least one entry shown as MISSING.

Uncheck any entry found as MISSING and your code should run.

 

[Bleetz]

Hi, I did what you said, and it worked fine.

There was a reference missing.

Thanks for al