LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
RWN RWN is offline
external usenet poster
 
Posts: 104
Default Implied Option Explicit in XP??

In the VB Editor, is the "Tools-Options-Editor" "Require Variable
Declaration" selected?
Don't know if this would be your problem, but it seems related.
--
Regards;
Rob

Please reply to the NG, I'm already up to my eyeballs in Nigerian/South
African get rich letters
as well as "Microsoft Critical Updates" et al.
"Trip" wrote in message
...
Hello all,

Quick question here. It seems as though XP is enforcing "Option

Explicit"
even though I don't issue this command anywhere in my VBA code. The

code
runs fine in other versions of Excel, but in XP it hangs anywhere I

have not
explicitly defined a variable's type. Does anyone know why and/or

what's
going on? Any direction would be greatly appreciated.

Thanks!

Trip




 
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
Option Explicit [email protected] Excel Discussion (Misc queries) 5 April 30th 08 11:19 PM
calculate implied ytm Azzurra New Users to Excel 2 October 23rd 06 06:52 PM
option explicit Dave F Excel Discussion (Misc queries) 2 September 5th 06 02:46 PM
Implied Compound Interest? dazman Excel Worksheet Functions 4 January 6th 06 06:01 PM
Option Explicit and Arrays Harlan Grove[_5_] Excel Programming 3 July 22nd 03 12:51 AM


All times are GMT +1. The time now is 07:44 AM.

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"