Two ways

Copy the whole sheet and use code to delete the VBA code
http://www.cpearson.com/excel/vbe.htm

Or Add a new sheet to the workbook and use Cells.copy to copy all the cells
from the Worksheet you want in this new worksheet.

If you need a code example post back




--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"MWE" wrote in message ...
I wish to copy sheet "A1" from workbook "A" to
workbook "B" but not copy the VBA code associated with
A1. How might that be done?

Thanks

Ron: many thanks. You have steered me to the solution of
my particular problem and solutions to a dozen other
things I have been pondering.

MWE

-----Original Message-----
Two ways

Copy the whole sheet and use code to delete the VBA code
http://www.cpearson.com/excel/vbe.htm

Or Add a new sheet to the workbook and use Cells.copy to
copy all the cells
from the Worksheet you want in this new worksheet.

If you need a code example post back




--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"MWE" wrote in
message ...
I wish to copy sheet "A1" from workbook "A" to
workbook "B" but not copy the VBA code associated with
A1. How might that be done?

Thanks


.