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

Bill!

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>!