Cell.Find
Can anyone suggest an alterantive to Cell.Find or help me with the correct
code please.
Error message is:
Active method of Range class failed
The Cell.Find is run in spreadheet X
Cells.Find(What:=SCN, After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext,
_
MatchCase:=False).Activate
SCN is a value in spreadsheet Y
I have tried being specific with Workbooks("Y").Cell.find etc etc but get
error:
Object doesn't support this property or method
Need to lookup a value in spreadsheet Y and retieve a value in the cell next
to the value of SCN
Thanks,
K
|