Hi TWIMC,

I'd like to add one name range that works on each sheet. E.g. I set a named
range called My Data and when I click on it, it selects the A2 to B10
depending on which sheet is active, how do I do it?


TIA
KM