Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Avanced
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel Avanced
Resolved · Medium Priority · Version 2003
Reply Wed 13 Apr 2011, 15:20Delegate Jinyan said...
Jinyan has attended:
Access Introduction course
Excel VBA Intro Intermediate course
Excel Advanced course
Access Intermediate course
Access Advanced course
Project Management course
Excel Avanced
How to make a dynamic name range in a worksheet
For upcoming training course dates see: Pricing & availability
RE: Excel Avanced
Hi Jinyan
Thanks for your question
If you go to insert-Name and then define. Click new and give the range a meaningful name. In the refers to box type
=OFFSET($A$2,0,0,COUNTA($A$2:$A$200),1)
Here the named range starts at Range A2 and then nests the countA function within the offset function. This counts down from A1 to the last cell in the column that contains a value
I enclose an example worksheet
Hope this helps
Regards
Stephen
Attached files...
Dynamic Named range.xlsWill be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
|