Use cell address, not its value, as a function argument

[markjkubicki]

(sorry about the massive subject title - accidentally hit entry before proofing)

________________________
it's been forever since i programmed in excel; and, of all things, i'm stuck at XL101

the formula starts
Function Sum_till_blank(rTarget As Range, vOffset As Integer)

where rtarget ought to be a cell ADDRESS, and vOffset is a number
for a in-cell formula entry "= Sum_till_blank(B29,3)"
the arguments received are
rTarget = "the value of cell B29", NOT the cell address (which is what i want)

it's such a simple issue, continual web searching is making me insane


with much thanks in advance,
mark