Fantastic... that works fine! Cheers :)

"ellmcg" wrote:

You need to use Paste Special - Copy the cells as usual, then right click
where you want to paste them. Select Paste Special, then 'Values'.

"Matt in a spot of bother" wrote:

Situation: I have a column of values, derived from adding, subtracting, etc,
corresponding values in other columns. So although the worksheet shows the
values, the cells are really just the result of a formula using other cells
on the same sheet.

Problem: I want to copy only the column of values to a new sheet. Instead I
get a column of REF errors, since the column refers to columns/cells which
don't exist on the new sheet. I just want the numerical values copied and
pasted!