LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Compile Error: variable not defined

I just distributed a new version of a complex workbook with lots of VBA code
to users who had been running an earlier version. I made some changes to the
code, tested the new version rigorously before sending it out, and it ran
fine. Now at least 2 users are reporting that they get a "Compile error:
variable not defined" when they try to run the main macro. I rechecked my
copy and ran it without error. Then I opened the copy they sent back to me
and ran it without error! I tried compiling both copies and they compiled
without error. So it works for me but not them--and they had successfully
run the prior version, so it doesn't seem like it would be something in their
environments. What could possibly be causing this error?

Judy Hopkins
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Variable not Defined Compile error Paul3rd Excel Programming 15 January 5th 08 03:22 AM
Compile error, Variable not defined RJR[_2_] Excel Programming 4 March 23rd 07 02:21 AM
Incremental Numbering: Compile Error - Variable not defined BEEJAY Excel Programming 9 September 27th 05 08:59 PM
Variable not defined compile error Phil Hageman[_4_] Excel Programming 4 June 17th 05 01:52 PM
Compile error, variable not defined davegb Excel Programming 5 May 19th 05 04:41 PM


All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"