How to display the address of the active cell in another cell on a google spreadsheet?
<p>I have a solution in excel that I would like to replicate in google spreadsheets. In excel I have  spreadsheet of 1600 lines of sales and forecast data and have a graph in the frozen pain section that displays the data from which ever row the cursor is on.</p>

<p>The VBA code in excel is:</p>

<pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

Range("A1").Value = ActiveCell.Address

End Sub
</code></pre>

<p>I can get the google spreadsheet to display the value of a cell in another specific cell but I need the actual cell address rather that the value to be displayed in cell A1.</p>
