Named range

M

Mark

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
 
C

Chip Pearson

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
 
T

Tom Ogilvy

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.
 
M

Mark

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...
 
Top