Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Throws Error 91
As any dedicated hacker would do, I have taken some code that works in a
macro and transplanted it. In the original code, I was popping back and forth between WS in a single WB. This hack involves two WBs: Windows("Copy of 2003-07 Terminations.xls").Activate With Range("B6", Range("B" & Rows.Count).End(xlUp)) 'Assume you have header rows For Each rngCell In .Cells rngCell(1, 1).Select varName = rngCell(1, 1).Value Selection.Copy Windows("Job-Personal-Fed and State Taxes Trimmed-3.xls").Activate Range("A1").Select Cells.Find(What:=varName, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate ...and when I step through it to the Find statement, I get "Object variable or With block variable not set". I read the help file on this, but couldn't relate what it was trying to tell me to my code. Where did I go wrong, mother dear? -- Dave Temping with Staffmark in Rock Hill, SC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook.open throws 1004 error | Excel Programming | |||
How do I perform a certain function if VBA throws up an error? | Excel Programming | |||
[Q] Save As throws type mismatch error in control's code? | Excel Discussion (Misc queries) | |||
Format statement no longer throws an error | Excel Programming |