Removing Option Explicit crashes excel

[mahmed1]

Hi All

Was wondering if anyone else encountered any issues with this. I have multiple modules

I have noticed that If I remove that line of code it crashes my whole system so was hoping someOne could explain if this is a known issue and why this happens

 

[BSALV]

option explicit has advantages and disadvantages.
As starter, i strongly advice to use it and declare all variables as string, integer, long, range, variant, ... .
But later, as you are more experienced, you can be less rigide.
When excel crashes, then i look why and sometimes declare that variable.

For example, to prevent situations where you look something in a range and it isn't there and so you cope with error messages

dim c as range
on error resume next
set c=range("A1:Z100").find what:="impossible value"
on error goto 0
if c is nothing then ...

But now you started a big discussion between believers and non-believers ...

 

[RoryA]

You don't need an error handler with Find though...

 

[mahmed1]

Thank you
So by not declaring a variable excel can crash?

Mine crashes when looping through connections as ive not defined what a con is - im not sure what to define as

For eg

For each con in activeworkbook.connections

 

[mahmed1]

This is my code which often comes up with a busy connection message too which i need to get around

Sub Refresh()

Dim conn As Variant

For Each conn In ActiveWorkbook.Connections
conn.ODBCConnection.BackgroundQuery = False
Next conn

ActiveWorkbook.RefreshAll
End Sub

 

[BSALV]

Connections, i'm not familiar with that, sorry.