Cody Vance
asked on
Find Name, Insert Value & Format
Hi Experts,
I received help with the attached file from other experts and just ran across an issue. The Sub StreetTeam should find all names in the "Macro Completed" sheet Column G that are in the "Names" sheet Column A, replace the value in Column E with the ShortName from the "Names" sheet and do some simple formatting. It works for some rows, then errors out saying apllication-defined or object-defined error. Seems like it starts referencing the wrong lookup values? I cant really tell. Any help is appreciated.
Thanks,
Cody-
Sample.xls
I received help with the attached file from other experts and just ran across an issue. The Sub StreetTeam should find all names in the "Macro Completed" sheet Column G that are in the "Names" sheet Column A, replace the value in Column E with the ShortName from the "Names" sheet and do some simple formatting. It works for some rows, then errors out saying apllication-defined or object-defined error. Seems like it starts referencing the wrong lookup values? I cant really tell. Any help is appreciated.
Thanks,
Cody-
Sample.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
By restrict the search range G, the4 next find cell is G27 instead of E27.
Sample-1-.xls