Auto Create Excel Named Ranges

A macro for creating named ranges in a spreadsheet. The generated names are local in scope.The macro requires that at least one row of two adjacent cells be selected. The text in the left cell is used to define the name of the cell on the right. Note that there is no real error checking here.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.