insertnamedefinename itin the refers to box touch the f2 key and then
type in
=offset($a$2,0,0,counta($a:$a),1)
touch enter. Now the range is self-adjusting for additions and deletions.
If you want to make it so that if you delete a2 then use
=offset($a$1,1,0,counta($a:$a),1)

Merry Christmas from Texas

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Arthur Pappas" wrote in message
...
*I'm using Excel 2007*

1. Sheet2 cells A2 A6 of my workbook constains a list (expense
categories). I selected these cells & typed EXPENSES in the name box.

2. Sheet1 is selected. I go to the 'Developer' tab, 'Insert', then I
select
'Combo Box' (form controls). I place my Combo Box in C1. I right click the
Combo Box, select 'Format Control', then in the Iinput Range I type
EXPENSES.

3. All works fine until I add another line to the EXPENSES list on
Sheet2!!!

All I ask is one simple question:

How can I make the EXPENSES column grow/shrink to my needs & have that
info
reflected in my Combo Box?

I am at my wits end & can't remember cursing so much since high school!!!