Hi there,
A couple things about your code before we get into the nuts and bolts of it. In your declared variables you have this line...
Only the second item is declared as a ListObject, while the first is a Variant type which will be set when it's first used. All variables should be independently declared. So to declare them both as ListObject object types, it would need to be this...
This holds true of all your variable declarations.
Also, you've declared some range variables as your list columns data body range. That makes sense, but then later on you're setting other variables to the same thing. For example, you set the TaItemCol variable to the list column "Item" of the "FFE" table, and then inside your loop you use this line...
This makes the rngSearch variable completely superfluous.
Just in briefly looking at your code, I'm not sure it's doing what you want. Your'e looping through every cell in the Items table, not just a single column. From what I can tell, your "Item" field in the Items table are all unique values, and you're wanting to update all rows in the FFE table with those matching "Item" field values from the Items table. Is that right?
This can be done without looping. I'll work on the code if you can let me know if I'm looking at this correctly.
Bookmarks