What are Range Names?

Range Names is another of Excel's feature that makes life of its users a lot easier.

A Range Name, as the name explains itself, is a Name that is given to a cell or a range of cells. This Name then can be used at other locations to refer to the defined range.

Name ranges can be defined in 2 ways:
  1. Using the Insert –> Name –> Define command in Menu bar
  2. Using the Name box (adjacent to formula bar) directly
Advantages of using Name Ranges:
  • Range names are used in soft-coding of big and complex models. Not just complex, range names can also further simplify simpler models
  • They make formulas easier to understand and read. They can add meaning to boring formulas by providing them with names
  • They are very useful in situtations where VBA coding is used. If a VBA code uses a cell reference and that cell's value need to some other place, the range names can come very handy in such cases


Share on Google Plus

About Nifty Guru

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Sunday, August 30, 2009

What are Range Names?

Range Names is another of Excel's feature that makes life of its users a lot easier.

A Range Name, as the name explains itself, is a Name that is given to a cell or a range of cells. This Name then can be used at other locations to refer to the defined range.

Name ranges can be defined in 2 ways:
  1. Using the Insert –> Name –> Define command in Menu bar
  2. Using the Name box (adjacent to formula bar) directly
Advantages of using Name Ranges:
  • Range names are used in soft-coding of big and complex models. Not just complex, range names can also further simplify simpler models
  • They make formulas easier to understand and read. They can add meaning to boring formulas by providing them with names
  • They are very useful in situtations where VBA coding is used. If a VBA code uses a cell reference and that cell's value need to some other place, the range names can come very handy in such cases


What are Range Names?SocialTwist Tell-a-Friend

0 comments:

Post a Comment