| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What reference libray?
Hi,
I don't know which reference library to use to make simple things like UCase, LCase, Mid, etc. work. (I'm getting compile errors after switching Excel versions...) Many thanks, JvL |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference libray?
Hi JV,
You don't need any reference library.Proably the error is due to missing references Open VBA IDE go to Tools-Reference and uncheck any missing libraries Thanks Xcelion "JVLin" wrote: Hi, I don't know which reference library to use to make simple things like UCase, LCase, Mid, etc. work. (I'm getting compile errors after switching Excel versions...) Many thanks, JvL |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What reference libray?
Thanks Xcelion! That did the trick.
I added "VBA." before the function and that worked also, but I hadn't noticed the references to missing libraries, so it's good to get rid of those too. Regards, JvL "Xcelion" wrote: Hi JV, You don't need any reference library.Proably the error is due to missing references Open VBA IDE go to Tools-Reference and uncheck any missing libraries Thanks Xcelion "JVLin" wrote: Hi, I don't know which reference library to use to make simple things like UCase, LCase, Mid, etc. work. (I'm getting compile errors after switching Excel versions...) Many thanks, JvL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
| Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) | |||
Linear Mode
