I have a Function that I wrote in VBA that tkes a lot of data from a lot of
places and computes a value. To help other people interpret the number I
would like to do one of the following:

1) Have the function leave a comment on the cell it was just calculated in.

2) Find the cell offset by n rows and fill it full of text from the
function.

So normally I'd type something like this in Cell BB9 for example:

=CPEFloorModel(AT9,$AJ$9:$AJ$88,AT$9:AT$88,$F$9:$F $88,R$9:R$88)

I want cell BB9 to have a comment left by the function or have the function
write text to cell BB(9+n)

Any hints would be appreciated. I'm using Excel 2003 if that matters.

-Jason