Duke, my explanation used kinda tortured language. Pardon. Thank you for
your reply. James

"Duke Carey" wrote in message
...
disregard that comment - completely misread the question

"Duke Carey" wrote:

A udf cannot directly change the value any cell other than the one in
which
you call it.


"Zone" wrote:

I want my UDF to add a number to the value of the cell to the left of
the
cell invoking the UDF. I don't want to specify the location of the
cell. I
want the UDF to know what it is. So, if I put
=MyUdf(2) in cell B2, B2 would contain the value of A2 + 2. I thought
this
would be Application.Caller, but I can't figure it out! TIA, James