thiscell and udf
 

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.

thiscell and udf
 

On Dec 11, 7:11*am, cate wrote:
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