Hi everyone, I'm a VBA newbie and trying to learn more
I'm running Windows 7 and Office 2013.
I read this page, http://www.mrexcel.com/forum/excel-...l-basic-applications-define-named-ranges.html, but the code that was provided isn't exactly the same as what I am after.
I have the following scenario on a worksheet (see below), except in my specific case, I have about 70 different combinations of named ranges to create, so I have populated until row 70. I'm looking for a macro that will create a named range by taking the text string in A1, and making that the named range for the range reference in B1 etc.
<tbody>
</tbody>
Thanks in advance to anyone who can help me out
I'm running Windows 7 and Office 2013.
I read this page, http://www.mrexcel.com/forum/excel-...l-basic-applications-define-named-ranges.html, but the code that was provided isn't exactly the same as what I am after.
I have the following scenario on a worksheet (see below), except in my specific case, I have about 70 different combinations of named ranges to create, so I have populated until row 70. I'm looking for a macro that will create a named range by taking the text string in A1, and making that the named range for the range reference in B1 etc.
A | B | |
1 | NamedRange1 | Sheet1:Sheet3!$A$1:$A$5 |
2 | NamedRange2 | Sheet1:Sheet3!$A$6:$A$10 |
3 | NamedRange3 | Sheet1:Sheet3!$A$11:$A$15 |
<tbody>
</tbody>
Thanks in advance to anyone who can help me out
Last edited: