captainxcel
New Member
- Joined
- Jul 28, 2017
- Messages
- 35
- Office Version
- 2016
- Platform
- Windows
Hello,
What would be a good code to loop through a list of account numbers all in a row buttressed by a blank row at the end and name these as (single cell) named ranges with the format XXX_ACCT1, XXX_ACCT2, XXX_ACCT3, etc. assuming that XXX is found in a cell. In the attached screenshot B5 through B12 would be named. Thanks in advance!
What would be a good code to loop through a list of account numbers all in a row buttressed by a blank row at the end and name these as (single cell) named ranges with the format XXX_ACCT1, XXX_ACCT2, XXX_ACCT3, etc. assuming that XXX is found in a cell. In the attached screenshot B5 through B12 would be named. Thanks in advance!