*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!!!