I'm stumped, Function that leaves a comment
 

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

I'm stumped, Function that leaves a comment
 

Take a look he

http://j-walk.com/ss/excel/odd/odd06.htm

--
Regards,

Juan Pablo González

"Jason Mondanaro" wrote in message
...
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