Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Trap Not Working
Excel 2002, WinXP
I have List1 on one sheet, List2 on another sheet, and a third sheet selected. Many items in List1 are not in List2. I have the following code with a simple error trap that is not working. I am getting an "Object variable not set..." error on the FoundCell.......Find line. I am not seeing how that error could not be trapped. What am I not seeing? Thanks for your help. Otto For Each i In List1 On Error GoTo Nexti FoundCell = List2.Find(What:=i, LookAt:=xlWhole) 'Copy/Paste FoundCell & stuff Nexti: On Error GoTo 0 Next i |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error.Type or IsError to trap #VALUE! and #NUM! | Excel Worksheet Functions | |||
File Name Exists Error Trap | Excel Programming | |||
Trap a DateValue Error | Excel Programming | |||
error trap | Excel Programming |