| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable not set
Hi all,
I have this, it returns the error "variable not set" Dim sSearch As String sSearch = InputBox("Enter String to Search", "Search") Application.Cells.Find(What:=sSearch, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate thanks so much in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variable not set
Hi,
There's nothing wrong with that snippet of code, your problem must lie in another part. Post all the code. Mike "RaulDR" wrote: Hi all, I have this, it returns the error "variable not set" Dim sSearch As String sSearch = InputBox("Enter String to Search", "Search") Application.Cells.Find(What:=sSearch, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate thanks so much in advance! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variable not set
You search string may be missing. Try this
Sub Mac() Dim rngTemp As Range Dim sSearch As String sSearch = InputBox("Enter String to Search", "Search") On Error Resume Next Set rngTemp = Application.Cells.Find(What:=sSearch, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False) On Error GoTo 0 If Not rngTemp Is Nothing Then Application.Goto rngTemp, True End Sub If this post helps click Yes --------------- Jacob Skaria "RaulDR" wrote: Hi all, I have this, it returns the error "variable not set" Dim sSearch As String sSearch = InputBox("Enter String to Search", "Search") Application.Cells.Find(What:=sSearch, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate thanks so much in advance! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variable not set
Is it perhaps that Option Explicit is set and you have incorrectly delcared
the variable? Or not at all? "RaulDR" wrote: Hi all, I have this, it returns the error "variable not set" Dim sSearch As String sSearch = InputBox("Enter String to Search", "Search") Application.Cells.Find(What:=sSearch, After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate thanks so much in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
| Nothing Keyword Destories Objects rather than just resetting the variable to an empty variable | Excel Programming | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
| Cells.Find error Object variable or With block variable not set | Excel Programming | |||
Hybrid Mode
