Hi Dave,

I'm afraid you'll have to be a lot more explicit. What formulas? What
function (code?)? What input values? What results did you expect? What error
exactly did you get?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Dave" wrote in message
om...
Hi,

I have a function which returns some values, but sometimes I don't
want to see all the results and so hide some rows.

When hiding some of the rows, some of the function input arguments
also get hidden.

This results in a recalculation of the formula. This would not
normally be a problem except that when the formula is recalculated
accessing properties like .Text returns an error. Pressing F2 on the
formula and enter to re-evalulate and everything is fine.

Has anyone come across this before and solved the problem (or not). I
would appreciate some help!

Thanks,
David