I am tyring to write a macro that will get the sheet name and cell address
and can be used to assign a range name to that sheet and cell. This is so
that should the cell address change the range name can still be assigned to
the correct address.

Archived from group: microsoft>public>vb>directx