Return Address Of Active Cell Using Excel And VBA - Exceldome

Home » Active Cell Address In Excel Vba » Return Address Of Active Cell Using Excel And VBA - Exceldome

Maybe your like

Return address of active cell

To get the address of an active cell you can use a combination of Excel ADDRESS, ROW and COLUMN functions, using Excel and VBA

EXCELVBAEXPLANATION

Example: Return address of active cell

Return address of active cell

METHOD 1. Return address of active cell

EXCEL

=ADDRESS(ROW(),COLUMN()) This formula uses the Excel ROW and COLUMN functions to get the row and column numbers of an active cell, respectively. These results are used inside the Excel ADDRESS function to return the address of an active cell (in the cell where the formula is written in).

METHOD 1. Return address of active cell using VBA

VBA Sub Return_address_of_active_cell() 'return the address of an cell ActiveCell = ActiveCell.Address

End Sub

Explanation about how to return address of active cell

EXPLANATION EXPLANATION This tutorial shows and explains how to return the address of an active cell, by using an Excel formula or VBA.

Excel Method: This tutorial provides a single Excel method that can be applied to return the address of the cell in which the formula is written in, using a combination of Excel ADDRESS, ROW and COLUMN functions.

VBA Method: This tutorial provides a single VBA method that returns the address of an active cell by referencing to the active cell and applying the Address function to it. FORMULA ADDRESS(ROW(),COLUMN()) ADDITIONAL NOTES Note 1: This formula will return the address of the in which it's written in. RELATED TOPICS

Related Topic Description Related Topic and Description
Average last n values in a column How to average the last n values in a column using Excel and VBA methods
Average first n values in a row How to average the first n values in a row using Excel and VBA methods
Average first n values in a column How to average the first n values in a column using Excel and VBA methods
Sum last n values in a row How to sum the last n values in a row using Excel and VBA methods
Sum first n values in a row How to sum the first n values in a row using Excel and VBA methods
RELATED FUNCTIONS
Related Functions Description Related Functions and Description
ADDRESS Function The Excel ADDRESS function returns a cell reference as a string, based on a row and column number
ROW Function The Excel ROW function returns the first row number of the selected reference
COLUMN Function The Excel COLUMN function returns the first column number of the selected reference

Tag » Active Cell Address In Excel Vba