Hello, When I add "Option Explicit" to the code below I get a Compile Error "Variable not defined" and "c =" is hilighted in blue.
When I delete Option Explicit from the code it works fine. Isn't "Set c =" explicit enough? Thnx for any help.
![]()
Option Explicit Private Sub cmdOK_Click() With Worksheets("eTicket_UBSPrintingGroup").Columns("A:A") Set c = .Find(Me.txtJobNumber.Value, LookIn:=xlValues) If Not c Is Nothing Then Me.txtJobTitle = c.Offset(0, 1).Value
Bookmarks