Copy Sheet into a New Workbook and Save it & Current Date

[@a.fleischbender7681]

Great turorial! Very educational

[@MyExcelLife]

Thank you a lot!

[@eleonoraa.c.1706]

Great tutorial, very helpful! Thx a lot! 😘

[@MyExcelLife]

Thank you!!

[@alializadeh8195]

Thanx

[@MyExcelLife]

You're welcome

[@sohelnirban5372]

Hello if I want to copy only specific range instead of full sheet then what would be VBA code ?? Could you please answer ??

[@MyExcelLife]

Hi, it depends where you would like to copy it - To the same sheet/workbook?

[@sohelnirban5372]

@@MyExcelLife no I want to copy specific range and paste in to new workbook then this new workbook autosave in specific folder

[@MyExcelLife]

@@sohelnirban5372 You can do it by following - you will open a new workbook and use copy range to the first sheet and then to save it

[@sunitaa1510]

Easy explain madi full sharcut key

[@MyExcelLife]

You're welcome

[@simondechoisy779]

Can I just say that using active workbook, activesheet and the sheet name as opposed to the sheet code name is something that no developer worth his salt would ever do.
Also you could simply assign to the new sheet rather than copying.

[@MyExcelLife]

Hi, thank you for your comment. Really there are several options to copy the sheet using vba. I explained one of them which is used by me.