I was hoping that someone could give me some direction.

I have a named range that I want to expand as the user adds more
records. The records will be added one or two at a time over a span of
months. I use the named range in a cobo-box on a user form. I will
eventually be using the user selection to match back to records in the
file (although a different worksheet)

Is there an easy way to automatically update the named range every time
I run the macro?

I don't have any coding to share yet, although I am working through it.

Thanks for any help.

Rob

Make the named range dynamic

eg

=A1:offset(a1,counta(a:a)-1,0)

would give you all records in column A

Aidan,

Thanks for the assistance. When I make the named range dynamic though,
it is just selecting a huge range, not what I am looking for. I want
to select 2 columns and right now 30 rows starting at G5... so G5:H35
(that's how the range is defined now). I will want the rnage to be
defined from G5 until G has no values in it. i.e. the named range will
stop if the column G and row X is null.

Thanks,

Rob

A dynamic range such as this should do EXACTLY what you want, and is
what I use reguarly on (for example) pivot tables that I want to read
from an uncertain data range

it may help to email me and I can send you an example file - my email
is

I have the named range working and automatically updating, but the
updating doesn't occur in the macro. I make a change to increase the
size of the named range, but the combo box that is referencing the
named range doesn't include the changes. The only way that I can make
it update seems to be if I select the combo box and then select the Row
Source location.. I can then save the userForm and run it, and the list
is complete again.

I need to be able to automatically update this, as I don't want users
not seeing the newly added names to the named range.

Thanks,

Rob

I'm assuming that the macro updates the data in the range, so at this
point it can reference the combobox - with another one of the bits of
code that looks a bit silly -

ComboBox1.RowSource = ComboBox1.RowSource


this will cause the data to refresh.