Hi Max,

Thank you for your reply. Please try the following.

Open a new workbook and enter ="This is a "&INDIRECT("Sheet2!A1") into cell
A1 of Sheet1. Enter ="TEST!" into cell A1 of Sheet2. Then go back to Sheet1
and note the words 'This is a TEST!' in cell A1. Then right-click on Sheet1
tab and click on the "Move of Copy..." option. Set "To book:" to the '(new
book)' selection, check the "Create a copy" box and click OK.

In the new workbook created after the OK, you should see a #REF in cell A1
of Sheet1. This is my problem.

Also, if you replace the INDIRECT with the name of a USER defined VBA
function, you will see #NAME rather than #REF. This is my other problem.

In advance, thank you for your help!

BG


"Max" wrote:

... 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