Refer to current (not active) cells location?

[jtb1492]

So I am writing a function. I want the value of the function to depend on the Row/Column location of cell in which the formula is being evaluated (so if I put = MyFunct() in cell C4 I want the returned value to depend on 3 and 4)

I know I could use row() and colun() as arguments to the function, but this seems like a not-so-elegant solution.

For a minute I though that ActiveCell.Row would be the answer, but then I realized that it's not...

Thanks for the help, guys. (In case it's not clear, I JUST started trying to use VBA)

 

[SkipVought]

Hi,

Are you in Access? Your terminology sounds like Excel to me.

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[jtb1492]

Haha...oops...as you can tell I can't read forum titles either...thanks

 

[SkipVought]

You might want Forum707 VBA

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}