Bill_Biggs
Well-known Member
- Joined
- Feb 6, 2007
- Messages
- 1,216
I have the following snippet of code:
<font face=Courier New><SPAN style="color:#00007F">On</SPAN> <SPAN style="color:#00007F">Error</SPAN> <SPAN style="color:#00007F">GoTo</SPAN> Alpha<br>LstRw = Cells.Find(What:=(B), After:=Cells(1, 1), SearchOrder:=xlByRows, SearchDirection:=xlNext).Row<br></FONT>
Now when B is not found, which is supposed to B a common occurence, it is supposed to goto a different section of the macro. Instead, I am getting the error statement "object variable not set." B is a variant and is established early in the macro. Anybody got any ideas?
<font face=Courier New><SPAN style="color:#00007F">On</SPAN> <SPAN style="color:#00007F">Error</SPAN> <SPAN style="color:#00007F">GoTo</SPAN> Alpha<br>LstRw = Cells.Find(What:=(B), After:=Cells(1, 1), SearchOrder:=xlByRows, SearchDirection:=xlNext).Row<br></FONT>
Now when B is not found, which is supposed to B a common occurence, it is supposed to goto a different section of the macro. Instead, I am getting the error statement "object variable not set." B is a variant and is established early in the macro. Anybody got any ideas?
Last edited: