Named range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created some lists in my spreadsheet. These lists are named ranges (I think).
How can I add more cells to a named range?

Thanks
 
Mark,

Press Ctrl+F3 to bring up the Define Name dialog box. In that
dialog, select the name whose range you wish to change, and
change the Refers To range at the bottom of the dialog.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
for a single column vertical range name List:


range("List").Resize(range("List").Rows.Count+3).Name = "List"

adds 3 cells to the bottom of the list.
 
Yes, it did the trick. Thanks

Chip Pearson said:
Mark,

Press Ctrl+F3 to bring up the Define Name dialog box. In that
dialog, select the name whose range you wish to change, and
change the Refers To range at the bottom of the dialog.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Click to expand...
 
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 set thick borders around non empty cells in range 0
Add sheet and name it unless it already exists 12
List sorting and macros 3
Would like to create customized named range 2
Post my named ranges in column A 10
Advanced Filter Error - I cannot spot my Error 3
How to hide password? 1
Name the range AFTER copied to new sheet 6

Back
Top