Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do you use find statement to find variant? My code:
Activecell.Value = varval On Error Resume Next With Sheets("Table").Columns("A:A") Set c = .Find(What:=varval, After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False) On Error GoTo 0 If Not c Is Nothing Then Question? Dose varval need to be in quotes? parenthethes? varval is a string. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving a Variant to Array | Excel Programming | |||
Find Variant | Excel Programming | |||
Variant as matrix | Excel Programming | |||
Variant Array | Excel Programming | |||
Variant to String | Excel Programming |