thiscell and udf

[cate]

Finally found my mystery problem; cannot use thiscell in a udf. To
discover the row in which the udf is called, must you pass in a row
number as a udf parameter? I wanted to use cell("row"), but it has
two specs. If I define the ref as the cell itself, that's not good,
right - "circular"? If I do not include the reference, cell() returns
the last changed cell... and I'm not sure what that is.

The only thing about entering a number is it doesn't adjust as the
cell functions are copied from cell to cell.

Thanks.

 

[cate]

Finally found my mystery problem; cannot use thiscell in a udf.   To
discover the row in which the udf is called, must you pass in a row
number as a udf parameter?  I wanted to use cell("row"), but it has
two specs.  If I define the ref as the cell itself, that's not good,
right - "circular"?  If I do not include the reference, cell() returns
the last changed cell... and I'm not sure what that is.

The only thing about entering a number is it doesn't adjust as the
cell functions are copied from cell to cell.

Thanks.

never mind...
Application.Caller.Address