Yeah, I'm with Paul on this: You can copy a whole range, then paste it over itself with values-only. Depending on your Excel version you get to the Paste-Special dialogue, but I usually just use the old <Alt-E>,S combination that I learned with an older version; my fingers have already memorized it and apparently they've allowed all subsequent versions of Excel to keep responding to it for backward compatibility.
I just had a belated thought, though: Do you really want to wipe out all the work you did typing in those proprietary formulae? They gotta be complicated, after all. Might be easier on you to copy the range and paste the Values to a different workbook; that way you can give the values to the end user without giving away the formulae you're using, yet you can keep the formulae around and reuse them instead of having to retype them.
And just to answer your question, yes, you can do it with VBA. But it may not be worth the effort to do that, unless you're doing this many times a day.
|