Thanks, Don. I did search help, but none of the search terms I could think
of pointed me to the answer.

"Don Guillett" wrote:

Have a look in vba HELP for PASTESPECIAL

--
Don Guillett
SalesAid Software

"auntpat" wrote in message
...
Using a workbook with income/expense worksheets for each month I would
like
to copy and paste the column totals for each month into a yearly summary
worksheet - but, of course, these cells are results of formulas, so I get
a
#REF error when they are copied to a new worksheet. Is there any way I
can
convert the cell contents to the actual figures that are displayed in the
cell? Thanks.

Aunt Pat