Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/ |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/ |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Format Problem - Date Overrides Format | Excel Discussion (Misc queries) | |||
problem format or something else )) | Excel Discussion (Misc queries) | |||
General Format to Custom format problem | Excel Discussion (Misc queries) | |||
Format problem | Excel Discussion (Misc queries) | |||
Format Problem | Excel Discussion (Misc queries) |