Cody Vance
asked on
VBA - Finad Names, replace Value & Format
Hi Experts,
I need some help with the attached Excel file. You can see the code I have for FindNames. This should look at each name in Column G in "Macro Completed" sheet, and if that name is listed in "Names" sheet, it should replace value in Column E of "Macro Completed" with value next to name on Names Sheet (ST Name) as well as perform some formatting, etc. Right now it only does it for the first instance of each name found. I need it to work for entire sheet.
THanks!
Cody-
Macro-Sample.xls
I need some help with the attached Excel file. You can see the code I have for FindNames. This should look at each name in Column G in "Macro Completed" sheet, and if that name is listed in "Names" sheet, it should replace value in Column E of "Macro Completed" with value next to name on Names Sheet (ST Name) as well as perform some formatting, etc. Right now it only does it for the first instance of each name found. I need it to work for entire sheet.
THanks!
Cody-
Macro-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.
ASKER
Guess I jumped the gun, getting Application object defined error on
fRange.Offset(0, -6).Font.Bold = True
fRange.Offset(0, -6).Font.Bold = True
ASKER
Cody-