Fri 16 May 2008, 16:45Delegate James said...
James has attended:
Excel VBA Intro Intermediate course
Option Compare Text
Can an Option be used with in an individual sub?
Tue 3 Jun 2008, 14:56Trainer Carlos said...
RE: Option Compare Text
James
The simple answer is NO
All Option Statements must appear at module level BEFORE any Procedures
Within a Workbook each Module can hold its own Option Statements that will be activated when the code in the Module is run
Hope this helps
Carlos
