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]