Enable JavaScript to interact with content and submit forms on Wolfram websites. Learn how

Mathematica Reference

Range Functions

ExcelRanges

• ExcelRanges[] gives a list of named ranges in the active sheet.

• ExcelRanges[sheet] gives a list for the specified sheet.

• ExcelRanges[book] gives a list of all named ranges in book.

• See also: ExcelRange, ExcelName.

Further Examples

In[1]:=

In[2]:=

Out[2]=

In[3]:=

Out[3]=

In[4]:=

Out[4]=

In[5]:=

Out[5]=

In[6]:=

Out[6]=

In[7]:=