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

try
:="SCN"
--
Don Guillett
SalesAid Software

"Kim Gardiner" wrote in message
...
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