Problem with format()
 

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

--
Message posted from http://www.ExcelForum.com

Problem with format()
 

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


---
Message posted from http://www.ExcelForum.com/

Problem with format()
 

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.

--
Regards,
Tom Ogilvy

"Bleetz " wrote in message
...
Hi, I seem to have some trouble with a couple of functions. Specially
with string functions like

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

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

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

Any help would be welcomed.

Thanks


---
Message posted from http://www.ExcelForum.com/

Problem with format()
 

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

There was a reference missing.

Thanks for al

--
Message posted from http://www.ExcelForum.com