But interestingly VBA automatically adjusts the range references in your
formula. I'd have thought all of the cells in the range would refer to cells
C7, K7 and would have put the formula in C30 and then filled or copied the
rest.

"Tom Ogilvy" wrote:

I agree. You could only use it for the problem you originally described
which doesn't appear to have much correlation to what you are now asking.

--
Regards,
Tom Ogilvy

"trice-nae" wrote in message
oups.com...
Hi - thanks again.

I don't really think I can use Tom's example in this case, because
there are too many inputs/calucations to take into the macro.

Item *seems* to work, so I'll run with it. I just kind of stumble on
these things, and never know if there's something i"m not taking into
consideration that'll make things work funny later....

thanks once more.