View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default how do I turn off option explicit statement in VB

select the line that says

Option Explicit

at the top of the module and delete it.

Of course the standard advice is to fix the problems identified by Option
Explict - otherwise, you may not get correct results even it it runs.

--
Regards,
Tom Ogilvy


"glen" wrote in message
...
I can't get some projects to work without turning it off but have no idea

how
to do it.