Question

i show the name and address of an active cell object or selected cell range
​

Answer 1

Explanation:

While using the Microsoft Excel, you can easily get the location of currently selected cell in the Name Box which lists on the left of the Formula Bar. But if the cell is named, you can’t examine its location based on the displaying on the Name Box. And if you want to directly show the full address of the active cell, or display the address of active cell in a specified cell, what would you do? In this tutorial, we will show you how to easily get the address of the active cell with formula and VBA methods.