Problem with format()

B

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

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?
 
T

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.
 
B

Bleetz

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

There was a reference missing.

Thanks for al
 
Top