What will c1 and c2 be declared as? Range?

Thanks

On Jan 26, 11:09*am, Joel wrote:
header = "Name"
Data = "123"
set c1 = rows(1).find(what:=Header,lookin:=xlvalues,lookat: =xlwhole)
if not c is nothing then
* set c2 = c.entirecolumn.find(what:=Data,lookin:=xlvalues,lo okat:=xlwhole)
end if



"Neka" wrote:
Hello,
Please I'm writing a macro that is suppose to search a worksheet and find a
specificcellin arowthat matches what the user enter in the search box.
Once the data matches acellon arowthen I want to performanothersearch
on the column that corresponds to therow.
So first a horzontal search on therowto find matchingcelland then a
vertical search on the column to findanothermatchingcell- Hide quoted text -

- Show quoted text -