hi..

I have to select a value from one sheet and find this value
in another
sheet. The problem is ... there are some 800 such values. I
am selecting a
value from sheet and then activating the other sheet again.
off course this
is not a correct way...as the sheets keep blinking! I think
i need to use
arrays....but still i am unable to figure out the exact
methood...

here is my code:
i = 2
While i <= lastCellNum
fam = check_fam(Cells(i, 3))
'RETRIEVE FINAL PACKAGE FAMILY FROM
"PackageMasterFile.xls"

Workbooks("PackageMasterFile").Worksheets("Package ").Activate
Set Ofind = Columns("A:A").Find(fam)
If Ofind Is Nothing Then
'MsgBox (fam)
MsgBox "The particular Family not found in
PackageMasterFile.xls"
Exit Sub
Else
'MsgBox (Ofind.Address)
extractValue = Ofind.Offset(0, 1)
Workbooks("best").Worksheets("raw_data").Activate
Cells(i, 4) = extractValue
End If
i = i + 1
Wend

any help?

thanks
monika