Norton5150
New Member
- Joined
- Jul 11, 2003
- Messages
- 22
I have this statement in the middle of a For Next loop
TB_Val = Range("F" & R.Find(What:=TB_Lookup).Row).Value
Trouble is when I try to Find a value that doesn't exist, I get a run-time error '91', object variable or with block variable not set
I've tried handling this with error handling and also with turning off alerts, but neither one helped me.
My Error handling I tried, On Error Resume Next, which ironically seemed to work 1 time through the loop then ignored that.
Thoughts? Thanks
TB_Val = Range("F" & R.Find(What:=TB_Lookup).Row).Value
Trouble is when I try to Find a value that doesn't exist, I get a run-time error '91', object variable or with block variable not set
I've tried handling this with error handling and also with turning off alerts, but neither one helped me.
My Error handling I tried, On Error Resume Next, which ironically seemed to work 1 time through the loop then ignored that.
Thoughts? Thanks