How do I programmatically know the current cell's address

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

Question:
Given a formula, say f(x), assigned to any given cell, c
(n,m), I need to know n and m. Can any one help me?

Thanks

kc
 
Not sure what your given f(x) has to do with it, but you can find
the row and column numbers for any cell as

Dim n As Long
Dim m As Integer
Dim cell As Range
Set cell = <given cell>
With cell
n = .Row
m = .Column
End With


If you're talking about worksheet functions instead of programming,
then for f(x) = SUM(n, m):

=SUM(ROW(),COLUMN())

will give the sum of the row number and column number.
 
Another possibility

Sub TestPrecedents()
Range("A1").Formula = "=C9^2"
Set rng = Range("A1").DirectPrecedents
MsgBox rng(1).Address & " row: " & rng(1).Row & _
" col: " & rng(1).Column

End Sub
 
If you put

=f(x)

in a cell and have UDF

Public function f( x as Range)
set rng = application.Caller


End function

Then rng will contain a range reference to the cell containing the =f(x)
which as fired the Function for calculation.
 
Back
Top