... a copy "values only" of a complete worksheet

If you do an entire source sheet copy paste special values ok over to
a new sheet in a new book, think you shouldn't be getting any error values
...
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"BG" wrote in message
...
I am trying to do into a new
workbook. However, the new copy has #REF in each cell where the original
workbook referenced the INDIRECT function. Is there any way around this?

Also, I get a #NAME in the new copy for each cell that had a used defined
function in the original worksheet.

Thanks, BG