handygaq.blogg.se

Finding vba in excel 2016
Finding vba in excel 2016







I tried utilizing an 'activecell' approach but that isn't giving me the correct location within the table. Where I am coming up short is figuring out the ListObject approach to do this correctly. I think I have the second part working correctly Then insert/copy a row (from the first table) into the second table ABOVE the row where the instance was found (in the second table).or if no instance exists: add a new row at the bottom of the second table and insert/copy the row there.Then find the first instance of that string in a second table (if it exists).

finding vba in excel 2016 finding vba in excel 2016

Loop through first table to get a string to search for.I am new to programming and trying to grasp the concepts.









Finding vba in excel 2016