Replies to post #33227 on A.I.M. Users Bulletin Board (AIMUSERS)

[Conrad]

Thanks Larry,

I done all that, plus more, except the matrix functions. . .(never used any yet).

Tip When you are editing a cell that contains a formula, you can press F9 to permanently replace the formula with its calculated value.

But you can undo that, so it is not permanent until the change is saved.
Well, in any case, this appears that F9 would do the same then as the manual Copy & Paste Special. If it does do for one cell it might also work for a block of cells after selection a block of Cells and pressing F9. . . .trying. . . . NO! This F9 works only on a single cell that one has activated!

Regards,