Find Method with list
I'm trying to use the find method in a With statement and in the Find
arguments use a list. Can I do this? If so what is the correct list
separator"
I'm trying:
With ActiveSheet.Rows(1)
Set c = .Find(["CODE","CONFIG"], LookIn:=xlValues)
Set c = .Find("CODE","CONFIG", LookIn:=xlValues)
Etc and cant seem to get ti to work, the code that follows activates
the location of the find but what I try the lists, the activated cell
seems random, and not the actual location of the cell with the variable
in it.
Thanks
Robert
|