Extending Named Range

The UK's most regular instructor-led training courses.
Training information: excel+courses+in+london · Excel courses london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

3 posts

ReplyWed 20 Jan 2010, 15:06Delegate Shreyas said...

Shreyas has attended:
Project Intro Intermediate course
Excel Intermediate course
Excel Advanced course
Visio Advanced course

Extending Named Range

How do you extend a named range?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	0	FULL
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	7		£445	£450
2007	Wed 28 + Thu 29 Apr 2010	Bloomsbury	6		£445	£450
Full Schedule: See all 35 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

755 posts

ReplySun 24 Jan 2010, 14:21Trainer Stephen said...

RE: Extending Named Range

Hi Shreyas

Thanks for your question

Create a named range by going to Insert-Name-Define.

Give your ranage a name and in the refers to box type the following equation

=OFFSET($B$1,0,0,COUNTA($B:$B),1)

This uses the CountA function nested within the Offset function.The offset function specifies a start point of cell B1 and a finish point based on the number of populated cells in column B.

Hope this helps,

Regards

Stephen

Sun 31 Jan 2010: Automatically marked as resolved.

· Utilise the web's information banks with Microsoft Excel
· Easing the Transition to Excel 2007
· Fun Things I've Done With Excel
· Identifying Suitable Candidates For VBA For Excel Training
· Microsoft Excel Training - Numerical excellence for all

Please browse our web site to find out more about
excel+courses+in+london and other Microsoft training courses.

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips