Range Naming Macro, Please Help
Posted by Herb B. on November 06, 2001 5:37 AM
I originally posted the following:
I have a spreadsheet with many schedules and each schedule occupies a range of cells that will not change. I want to create Range Names for each schedule that I can use for navigating the spreadsheet and printing. The trick is that I want each Range to be named based on text in a cell located in each schedule. I want a macro to do this for me and whenever I evoke the macro the Range will be renamed based on the entry in the cell.
Well here is my attempt at a Macro to get this done so that someone might understand what I want:
I want to repeat this to name 50 or 60 distinct ranges in the worksheet based on the entry in a cell. Can this work?