Dynamic Range Names
Posted by Herb B. on November 03, 2001 11:45 AM
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.
I have seen this done in much earlier versions of Excel or Lotus but can quite figure it out. Thanks.