How do I programmatically know the current cell's address
 

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

How do I programmatically know the current cell's address
 

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.

In article ,
"Keith" wrote:

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

How do I programmatically know the current cell's address
 

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



--
Regards,
Tom Ogilvy

"J.E. McGimpsey" wrote in message
...
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.

In article ,
"Keith" wrote:

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

How do I programmatically know the current cell's address
 

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.

--
Regards,
Tom Ogilvy


"Keith" wrote in message
...
To clarify f(x):

f(x) will be the sum of two cells in columns located to
the left of the current cell and x number of rows up + all
of the cells in the current column and current row for x
number of rows. x is user definable and dynamic.

x is the leadtime in days of the receipt of product the
two columns to the left of the current cell are the daily
on hand quantities (OHQ) and daily issues (I) of the
product. When the sum of the OHQ - I + the sum of all
receipts during the present defined leadtime fall below a
lower limit, f(x) will return a new receipt.

I am modeling a purchasing system to allow our percurment
people visiblility of several system defined variables.

Hope this helps.

kc

-----Original Message-----
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.

In article ,
"Keith" wrote:

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
.