Results 1 to 3 of 3

Compile Error

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2008
    Posts
    17

    Compile Error

    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
    Last edited by dominicb; 01-16-2008 at 01:43 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1