Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
offset.cell | Excel Discussion (Misc queries) | |||
VBA Cell.find | Excel Discussion (Misc queries) | |||
Cell.Find in VBA | Excel Discussion (Misc queries) |