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