Next without For error in nested loop - Escaping a Nested Loop?

Hi,
I am trying to figure out a way to run a Vlookup on a Cell in my "System File" by checking a table in a "New Data" File. HOWEVER, if there is an #N/A error, I want the cells' values to be unchanged. I've come up with the following, however, I keep getting a "Next without For" error. Is it possible to escape a nested For Next loop?

The tl;dr semantic version:

Please Login or Register  to view this content.

My more or less actual code is as follows:

Please Login or Register  to view this content.

Thanks in advance for any insight on how to accomplish this task.

Hi

If you only want to process something when there is a result, then make the if statement reflect that, and allow the loop to function normally.

Using your pseudo code approach to the if

for j = 1 to 3
set x = .find(thing)
if not X is nothing then
do whatever
end if
next j

Hopefully that will make sense.

rylo

I would take rylo's suggestion and re-write your code so you would not have to exit a loop.

--But if you have toooo ... the vba command to exit a For Loop is "Exit For" Again this is poor programming practive and leads to unmanagable code.



Ted

I guess it's the logic of testing "If Not X is Nothing" is a little weird to me in that I'll have to bury tests within one anothers' If-Then loops. Still, it works, I just don't like how the code plays out. Thanks much.