Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Microsoft Excel : Named Range

Posted on 2011-09-06
Medium Priority
Last Modified: 2012-05-12
i want to select rows of specific column with custom row as the start range.

My Named Range so far is :

but i want exclude the first row, i tried =Category!E2:$E but doesn't work ?
Also, in some sheet i want to select the data that starts from row 10 (till the end of row in a column) ?

Question by:veematics
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 85

Accepted Solution

Rory Archibald earned 1000 total points
ID: 36487165
If you specify a start cell, you must specify an end cell too:

=Category!$E$2:$E$65536 for example.

Or for a more dynamic range:

Assisted Solution

Unattended earned 1000 total points
ID: 36487307
Instead of
LVL 10

Expert Comment

ID: 36487351
Keep your named range as is (i.e. $E:$E) and try using the following formula for custom ranges.
Assuming that TEST is the name of you range,
For the list of data that starts from row 10

Open in new window

For the list of data that starts from row 2

Open in new window


Author Closing Comment

ID: 36487444
Thanks for the help

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question