Updating a Named range Automatically

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 aidan.heritage@virgin.net

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.