As usual, you should copy/paste your code for evaluation. It's good that you
told us the xl versions.

--
Don Guillett
SalesAid Software

"Meg" wrote in message
...
Hi,

Bear with me, first time poster, not very Excel-minded!

I have a macro (which I didn't write) that extracts information from
several Excel worksheets and complies it into one large summary
worksheet. (Basically the same thing as copying and pasting all the
data by hand.)

The problem is that the macro should just copy and paste the data
directly into the summary spreadsheet. Instead it seems to be pasting
links or references rather that just data.

So, instead of generating a summary worksheet with numbers/raw data, it
generates the worksheet filled with REF! errors. Is there a way to
change preferences to tell Excel to always paste values instead of
links?

Also, this only seems to be a problem with Excel 2000. It seems to run
fine with Excel 98.
Thanks!

Meg


---
Message posted from http://www.ExcelForum.com/