redefine named range

[rozner]

Hi,

This has been driving me crazy, I'm doing some VBA work and I haven't
touched Excel in a long time. I got all my VBA stuff done fine, but I'm
using named ranges to reference values from the spreadsheet.

My question is, how do you redefine a range, this must be possible.
I've had to move to a new workbook to do this but there must be an
easier way.

In case I'm making no sense, this is what I mean.

Make a selection on a worksheet, then in the top left there is a "name
box", enter a name, now you have a named range. If I later want to add
or remove from that named range, how do I do so without moving to a new
workbook.

Thanks

 

[rozner]

nevermind, after hours on this I figured it out myself, in case you were
wondering, the answer is:

Insert -> Name -> Define...

This has all the goodies I was looking for.

Sorry for the useless post.