I want to copy a set of cells that have a function in them from one worksheet
to another, how do I do this?

An easy way is to "unformulate" the formulas, making them simple text, then
copy and paste to the new location, and convert them back to working
formulas.

Select them all, then from the Menu Bar:
<Edit> <Replace>

In the "Find What" box, type the equal sign ( = ),
In the "Replace With" box, use something unique, like " ^^^ " (no quotes),
Then <Replace All>

Your formulas are now plain text.
Right click in the selection and choose "Copy",
Navigate to your new location and "Paste".

Then, just reverse the process:
<Edit> <Replace>

In the "Find What" box, type ^^^
In the "Replace With" box, enter the = sign,
Then <Replace All>


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"BrewsterGK" <(E-Mail Removed)> wrote in message
news:EDBD1130-C385-4A27-8CBF-(E-Mail Removed)...
I want to copy a set of cells that have a function in them from one
worksheet
to another, how do I do this?