I have a cell range identifier masquerading as a text entry in a cell
(e.g.,the cell at G19 contains the text "D14:F20"). Within my macro, I
want to grab that D14:F20 text string, convert it into a range
reference, and use that range reference within the macro. I can't
figure out how to make the text-to-range conversion.

Another question along the same lines: I have a single cell (e.g. B4)
and I want the text within that cell to echo its location (e.g., "B4")
such that if the cell is moved elsewhere the text revises appropriately
(e.g., if the cell moves from B4 to F9, the text within changes to "F9"
too).

(Using Mac Excel 2001.)

Relative newbie to this -- help(s) appreciated.

- Jim



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Put that string inside of the range object like the following

Range(Range("G19").Value)

NOTE: You may have to prequalify the Range Objects above. If left the way
it is, it will refer to the ActiveWorksheet within the ActiveWorkbook.

--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"jimredfield" wrote in message
...
I have a cell range identifier masquerading as a text entry in a cell
(e.g.,the cell at G19 contains the text "D14:F20"). Within my macro, I
want to grab that D14:F20 text string, convert it into a range
reference, and use that range reference within the macro. I can't
figure out how to make the text-to-range conversion.

Another question along the same lines: I have a single cell (e.g. B4)
and I want the text within that cell to echo its location (e.g., "B4")
such that if the cell is moved elsewhere the text revises appropriately
(e.g., if the cell moves from B4 to F9, the text within changes to "F9"
too).

(Using Mac Excel 2001.)

Relative newbie to this -- help(s) appreciated.

- Jim



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

assume it contains D14:F20 and not "D14:F20"
msgbox Range(Range("G19").Value).Address

=address(row(),Column(),4)

--
Regards,
Tom Ogilvy

"jimredfield" wrote in message
...
I have a cell range identifier masquerading as a text entry in a cell
(e.g.,the cell at G19 contains the text "D14:F20"). Within my macro, I
want to grab that D14:F20 text string, convert it into a range
reference, and use that range reference within the macro. I can't
figure out how to make the text-to-range conversion.

Another question along the same lines: I have a single cell (e.g. B4)
and I want the text within that cell to echo its location (e.g., "B4")
such that if the cell is moved elsewhere the text revises appropriately
(e.g., if the cell moves from B4 to F9, the text within changes to "F9"
too).

(Using Mac Excel 2001.)

Relative newbie to this -- help(s) appreciated.

- Jim



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Ronald / Tom - Tnx for the help on both questions. - Jim



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/