How to create a dynamic named range?

  • Thread starter Thread starter Sunita
  • Start date Start date
S

Sunita

Hi there,
Would like to create a named range that increased when I added rows - please
assist!!
Look forward to any help.

Merci!
 
Say your data start from 'Sheet1'!A5 and rows are added below. The
following dynamic range will be correct if you do not have any other
above A5:

=OFFSET('Sheet1'!$A$5,0,0,COUNTA('Sheet1'!$A:$A),)

Insert|Name|Define...

Enter the name for your dynamic range and then, in Refers to: enter
the above formula or its modification.

HTH
Kostis Vezerides
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
How do I set up a Dynamic Named Ranges in Excel 2007 7
Multiple Dynamic Named Ranges across Columns 3
Dynamic Named Ranges 4
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Capturing dynamic ranges 10
How to make a dynamic named range 4
Dynamic Range for multiple columns 7

Back
Top