type "option explicit" prior to sub

Phil_V Wrote:
How do I set the option in Excel VBA that I MUST Dim variable befor
using them? I would prefer it this way to the default where Excel jus
'creates' variables that are spelt differently etc.

Thanks,

Phi

--
kwiklearne
-----------------------------------------------------------------------
kwiklearner's Profile: http://www.excelforum.com/member.php...fo&userid=3190
View this thread: http://www.excelforum.com/showthread.php?threadid=52371