Create Multiple Named Ranges From List

[MV76]

Hi. I have a list of cell reference ranges and corresponding desired names. I have 100+ of these, but the attached example file only has 10 to simplify. Is there an efficient way to create named ranges based on these two columns, or do I have to create them one by one? Example file attached, and the list I am referencing is pasted below:

Name ACTUAL RANGE (Sheet & cell range)
NAME1 Sheet1!F3:H25
NAME2 Sheet1!A4:A75
NAME3 Sheet1!L29:L100
NAME4 Sheet2!Z5:AB100
NAME5 Sheet2!H15:H27
NAME6 Sheet2!BB15:BB45
NAME7 Sheet3!A10:B56
NAME8 Sheet3!F81:F100
NAME9 Sheet3!H8:H67
NAME10 Sheet4!A55:B70


Thanks for your help!

MV

[hrlngrv]

Presumably you want the named ranges to be absolute, so that once defined, e.g., NAME1 would refer to =Sheet1!$F$3:$H$25. Assuming so, make the top-left cell in the table of name-reference pairs the active cell (Sheet1!A2) and run

Please Login or Register  to view this content.

No error checking. If you run this with the cell to the right of the active cell not a valid range address, this will throw runtime errors.

The rng bit is unnecessary except to ensure that each defined name refers to a range.

[MV76]

Excellent, this did the trick. Thanks so much for your help, you saved me hours of effort and frustration!