I am writing a little function to interpolate between numbers - I need a way of discovering which cell the function is being called from, as i require the row number to calculate the interpolated value.

I have tried the ActiveCell method, but this seems a bit flaky

Thx in advance,
Aljrob