View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] IComeInTheWest@gmail.com is offline
external usenet poster
 
Posts: 7
Default Find Method Used within Values in an Array of Ranges

Hello,

I am trying to search through the elements in an array (each of which
is a range object).

I would like to use something like

set c=worksheets(1).myarray.find(1,lookin:=xlvalues),

but this doesn't work.

Any tips?

Regards,

Calvin