Results 1 to 4 of 4

Error - Object variable not set (Error 91)

Threaded View

Przemyslav Error - Object variable not... 10-21-2010, 12:36 PM
Leith Ross Re: Error - Object variable... 10-21-2010, 02:23 PM
Przemyslav Re: Error - Object variable... 10-21-2010, 02:53 PM
Leith Ross Re: Error - Object variable... 10-21-2010, 02:57 PM
  1. #1
    Registered User
    Join Date
    10-21-2010
    Location
    Poland
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Error - Object variable not set (Error 91)

    Hi everybody Nice to meet you. I need some help with VBA.

    I have worksheet, like this:

    http://radikal.ru/F/s15.radikal.ru/i...03dc3.jpg.html

    I have day-list. When i choose a day from this list, Excel should take me to another cell. This cell is ilustrated on third picture - column AK.

    http://radikal.ru/F/s59.radikal.ru/i...e331f.jpg.html

    http://radikal.ru/F/i061.radikal.ru/...3a719.jpg.html

    But when I choose day on list I have this error:

    Object variable not set (Error 91)

    When I click Debug button Escel shows me, that this line is wrong in VBA:

    Columns("AK").Find(what:=Target.Value, Lookat:=xlWhole).Select
    This is my all code for this function:

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count = 1 Then
    If Target = Range("C1") Then
      Columns("AK").Find(what:=Target.Value, Lookat:=xlWhole).Select
    End If
    End If
    
    End Sub
    What I do wrong ??

    P.S. My sheets have to be protect in Excel.

    Thanks for any help.
    Last edited by Przemyslav; 10-21-2010 at 03:25 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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