Naming non-contigent cells with vba
Garry,
I suppose you could do it either way, depending on the need. I understood from Howard's original question that this was to help with another poster's question. That post needed to name a range of cells on Sheet1 for use on Sheet2. By making the named ranges Global, I intended for the name reference to always refer to the cells on Sheet1, regardless of what sheet uses the reference.
Ben
|