Copy only takes som of the data

Hi.
I've been using a macro to copy a worksheet, the macro takes the values and format but not the formulas and saves that, it's been working great.
But now I've changed alot of the formulas in the worksheet and it doesn't take all data when it copies..

the macro is as follows:

Please Login or Register  to view this content.

(NOW YOU MAY SKIP DOWN A BIT, THIS DOESN'T REALLY GIVE ANY VITAL INFORMATION....)
the formulas in the cells that doesn't get copied is:

Please Login or Register  to view this content.

meaning approximately:

Please Login or Register  to view this content.

(SKIP TO THIS PART!!):

Where the data omitted is from the part

Please Login or Register  to view this content.

But when I leave only that I get a #REFERENCE error.
previously I used a formula where the equivalent part was

Please Login or Register  to view this content.

and that worked great!
The data is in the worksheet being copied in both instances but why do one work but not the other?

Any ideas?

In the following command (taken from your macro) intruction is to paste only the value of the copied data.

If formulas are copied it pastes the result of the formulas not the formulas

Please Login or Register  to view this content.

If you are wanting values, format, formulas to be pasted as copied then use the Paste command instead of the PasteSpecial command