Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi. All,
I've been using this code for some time without any problems, suddenly I get this run time error - Object variable or With block variable not set. Appreciate your help! Thank you Public Sub KryShtBld() Dim MatchSht, sht As Object For Each sht In Sheets If sht.Range("D1") = Range("bladsoek").Value Then Set MatchSht = sht Exit For End If Next sht With MatchSht sht.Activate <------------- Error here End With Exit Sub End Sub -- HJN |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run-time error 91: Object Variable or With block variable not set | Excel Programming | |||
Run-time error `91': Object variable . . . not set | Excel Programming | |||
Run-Time error '91': Object variable of With block variable not set | Excel Programming | |||
Run-time Error '91' Object Variable Not Set | Excel Programming | |||
Run-time error '91': "Object variable or With block variable not set | Excel Programming |