thiscell and udf

C

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top