Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Sep 2007
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Naming ranges (Excel 2003)

    Does anyone know a way to extend a name range as dates are added? Example: I have made a sheet with all the weekdays for a year, but I have been going through and naming all the Jan cells "Jan_A" "Feb_A" and so on. But, after this year, am I going to have to do it all over again?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Naming ranges (Excel 2003)

    Check out Microsoftt MVP Jan Karel <!profile=Pieterse>Pieterse<!/profile>'s article on Dynamic Names

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •