View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cate cate is offline
external usenet poster
 
Posts: 93
Default 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.