Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this code :-
Private Sub CommandButton1_Click() Dim FW As Variant Dim rngCell As Range FW = Worksheets("LU").Cells(1, 1).Value With Worksheets("Detail") Set rngCell = .Cells.Find(What:=FW, _ After:=.Cells(1, 1), LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, _ SearchDirection:=xlNext, MatchCase:=False) End With If Not rngCell Is Nothing Then MsgBox rngCell.Row End If End Sub Worksheets("LU").Cells(1, 1) contains value "109435" When running I get error "Run-time error 1004 - Unable to get the Find Property of the Range Class" Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Refresh produces #N/A error | Links and Linking in Excel | |||
Refresh produces #N?A error | Excel Discussion (Misc queries) | |||
Input box cancel produces error | Excel Programming | |||
Sorting a 2 column list with VBA using Worksheet change produces 1004 error | Excel Programming | |||
CreateObject produces error | Excel Programming |