Moving/Copying worksheets with formulars
 

Is there a way, using code, to copy (move) a worksheet to another worksheet
without losing the formulars which are contained in the copied worksheet.
I have a worksheet that I need to copy over to another worksheet, but
because the 1st worksheet contains formulars that are based on other sheets
in the workbook I know I will get and error. So I need to figure out a way to
move the 1st worksheet over with all the data on it intact.

Moving/Copying worksheets with formulars
 

first off open both worksheets (the one containing the sheet you want to copy
and the one you want to place it in)

right click on the tab of the sheet you want to copy, select 'move or copy',
then choose the filename of the worksheet where you want it.

i believe this should do it..hth!

michelle

"Ayo" wrote:

Is there a way, using code, to copy (move) a worksheet to another worksheet
without losing the formulars which are contained in the copied worksheet.
I have a worksheet that I need to copy over to another worksheet, but
because the 1st worksheet contains formulars that are based on other sheets
in the workbook I know I will get and error. So I need to figure out a way to
move the 1st worksheet over with all the data on it intact.