Posts by sv651

    I have 5 worksheets, each with about 3000 rows & 50 columns of (contiguous) data, that I would like to copy to a new workbook.

    I'll be doing this on a regular basis & am wondering if there's a super-efficient VBA-based approach to programmatically create a new workbook & transfer the contents of my 5 sheets to 5 sheets in the new workbook.

    Right now I'm planning on using the Copy method along with either:
    1./ Set newBook = Workbooks.Add; or,
    2./ Set ExcelSheet = CreateObject("Excel.Sheet")

    Any guidance appreciated!