Macro user defined function row information
Thank you exactly what I needed.
"Tom Ogilvy" wrote:
set rng = Application.Caller
set rng1 = rng.parent.Cells(rng.row,"F")
--
Regards,
Tom Ogilvy
"bj" wrote in message
...
I am writing a long macro User defined function which will be used in
multiple workbooks. it uses multiple inputs from the workbooks all of
which
will be in the same row. I have been using the =XXX(a,b,c,d,e,f,g,...)
but
would prefer no or just one transfer variable. The columns may change but
I
have a method of determining which column I need. My question is "How do
I,
either determine which row The particular UDF is in, or call for a value x
number of columns from the cell but in the same row?" (I know I could just
insert a column with "=ROW()" and reference it <and have done so in the
past
but would like a better method
[I am using EXCEL 2002]
|