Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Such a thing as CurrentCell..? ThisCell? | Excel Programming |