View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] robert.hatcher@l-3com.com is offline
external usenet poster
 
Posts: 55
Default 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