for a single column vertical range name List:


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

adds 3 cells to the bottom of the list.

--
Regards,
Tom Ogilvy


"Mark" wrote in message
...
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