Moving and deleting sheets in different workbook

[ogo]

Hi All,

Is it possible to delete a sheet from one workbook and then copy another sheet from a second workbook to the first one ? All to be done with macro in any one of the workbook?

Thanks,
Ogo

 

[Joe4]

Sure. If you use the Macro Recorder, you should be able to get the code you need. Just turn it on, perform your steps manually, then stop the Macro Recorder. You will have just recorded the code you need.

 

[ogo]

Thanks Joe, earlier it was not working because the sheet was hidden. Now i got it working.

Thanks,

Ogo