Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error
To all great minds out the
A number of people have just started having issues with some macros that I wrote a while ago which have been working fine up until now. There is a compile error that keeps coming up. Variable that were not declared are hightlighted which I have fixed by declaring the variable, however the big problem is when functions like Mid are highlighted as the problem. Does anyone have any idea on what to do to sort this problem out? Thanks, Peter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error
On any of the affected machines (with the spreadsheet open) in the VBE check
Tools - References and look for any references that are listed as "Missing:". You may be able to just uncheck the reference and it will work just fine. If not reply back with the name of the reference that is missing. -- HTH... Jim Thomlinson "Peter" wrote: To all great minds out the A number of people have just started having issues with some macros that I wrote a while ago which have been working fine up until now. There is a compile error that keeps coming up. Variable that were not declared are hightlighted which I have fixed by declaring the variable, however the big problem is when functions like Mid are highlighted as the problem. Does anyone have any idea on what to do to sort this problem out? Thanks, Peter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error
On 14 May, 16:05, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote: On any of the affected machines (with the spreadsheet open) in the VBE check Tools - References and look for any references that are listed as "Missing:". You may be able to just uncheck the reference and it will work just fine. If not reply back with the name of the reference that is missing. -- HTH... Jim Thomlinson "Peter" wrote: To all great minds out the A number of people have just started having issues with some macros that I wrote a while ago which have been working fine up until now. There is a compile error that keeps coming up. Variable that were not declared are hightlighted which I have fixed by declaring the variable, however the big problem is when functions like Mid are highlighted as the problem. Does anyone have any idea on what to do to sort this problem out? Thanks, Peter- Hide quoted text - - Show quoted text - Jim, Thank you for your help, it worked! Thanks again, Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |