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