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 |
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 |
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 |
All times are GMT +1. The time now is 08:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com