Thread
:
Cell.Find
View Single Post
#
2
Don Guillett
Posts: n/a
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
Reply With Quote