MrExcel Publishing
Your One Stop for Excel Tips & Solutions

INSERTing (not copying!) a WORKSHEET

Posted by Bill Roberts on February 10, 2000 8:59 AM

I read MrEXCEL's posts regarding the COPY of a worksheet within a workbook.

Tried variations but am unable to simply INSERT a FRESH worksheet.

How to?

Posted by bill roberts on February 10, 2000 9:05 AM


Your such a schmuck!

All you had to do was:

ActiveWorkbook.Sheets().Add after:=Worksheets(LASTSHEET)

Now you've gone and polluted the message base with usless FELDERCARB!

But since I am really you, I forgive me <GRIN>!