programmatically copy data from one workshet to another excel

The solution for “programmatically copy data from one workshet to another excel” can be found here. The following code will assist you in solving the problem.

‘This essientally clones the “Source” worksheet

ExcelWorkBook.Sheets(“Source”).Copy(After:=ExcelWorkBook.Sheets(“LocationSheet”))
ExcelWorkBook.Sheets(ExcelWorkBook.Sheets.Count).Name = “NewSheetName”

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts