Draw a selection around a set of cells, right-click on it, and pick "Define Name..." from the menu that appears to make a named range. Alternatively, at the "Insert" ribbon pick "Table" with a selection selected and then type a name for the table at the upper left in the ribbon. The tables and the named ranges will hopefully provide a better way to grab ahold of Excel data when parsing Excel sheets in code. This will hopefully be more reliable and less brittle than grabbing cells by column and row number.
No comments:
Post a Comment