Will,

Initially, the ranges can be identical, the named cells will be identical. After typing my request, it dawned on me that I could figure it out by recording a macro; so, I did that:[vba]Sub Macro1()
'
' Macro1 Macro
'

'
ActiveWorkbook.Names.Add Name:="FolioNo1", RefersToR1C1:= _
"='Sample Control Sheet'!R4C1:R50C1"
ActiveWorkbook.Names("FolioNo1").Comment = ""
End Sub[/vba]
I just need to write a small VBA program that iterates through the list of cells and ranges changing the sheet name (here 'Sample Control Sheet') and changing the number from 1 to 2, 3, 4, or 5, as needed. Finally, I can skip the Comment line since I'm not using it. This will then populate the Names file with the required information.

Will this work? Is there an easier or more elegant way to do this?

Thanks,