In the last post we created the "GROUP_1" named range.

After the range has been created, add the line:

MsgBox (Range("GROUP_1").Address)

This lists the cells that comprise GROUP_1
--
Gary's Student


"rml" wrote:

Gary's student had given me a very simple yet productive reply to my previous
post DEFINE NAME. Now I need to expand this answer to a little more
dynamic....Based from my previous post, I need to have an automatic
generation of a list of all the reference cells in blank "Group_1", lets say
in Column IV. wherein each cell here will contain the cell reference (e.g.
A2, J4). Hope Gary's will reply...thanks...