How do I programmatically know the current cell's address

[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

 

[J.E. McGimpsey]

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.

 

[Tom Ogilvy]

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

 

[Tom Ogilvy]

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.