Add a sheet tab for Every Day of the Month
44 هزار بار بازدید -
6 سال پیش
-
Add the dates of the
Add the dates of the month to sheet names in Excel, How to add a new sheet with VBA. How to format the date with VBA. How to rename a sheet with VBA. Check out my templates page for free and purchased templates https://www.easyexcelanswers.com/temp...
Check out my online training www.easyexcelanswers.com/courses.html
How to insert VBA code in Excel How to insert VBA code in Excel
Code
Sub add_new_sheet()
Dim sh As Worksheet, nsh As Worksheet
Dim nextdate As Date
Dim ndate As Date
Dim x As Integer
Dim startdate As Date
x = 1
Worksheets("Sheet1").Range("A1").Select
Worksheets("Sheet1").Range("A1").NumberFormat = ("dd-mmm-yyyy")
Worksheets("Sheet1").Range("A1").Value = Date
Cells.EntireColumn.AutoFit
startdate = Worksheets("Sheet1").Range("A1").Value
For x = 1 To 5
nextdate = startdate + x
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Range("A1").NumberFormat = ("dd-mmm-yyyy")
ActiveSheet.Range("A1").Value = nextdate
Cells.EntireColumn.AutoFit
ActiveSheet.Name = Format(nextdate, "dd-mmm-yyyy")
Next
End Sub
For more help visit my website http://www.easyexcelanswers.com or email me at [email protected].
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting http://www.calendly.com/easyexcelanswers
I am able to provide online help on your computer at a reasonable rate.
https://www.amazon.com/shop/barbhende...
Check out my next one-hour Excel Webinar
https://www.crowdcast.io/easyexcelans...
I use a Blue condensor Microphone to record my videos, here is the link
https://amzn.to/37gyyGa
Check out Crowdcast for creating your webinars
https://app.linkmink.com/a/crowdcast/83
If you need to buy Office 2019 follow
https://amzn.to/2VX5dv8
I use Tube Buddy to help promote my videos
Check them out
https://www.Tubebuddy.com/easyexcelan...
Follow me on Facebook
Facebook: easyexcel.answers
TWEET THIS VIDEO Add a sheet tab for Every Day of the ...
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
http://www.youtube.com/timedtext_cs_p...
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.
Check out my online training www.easyexcelanswers.com/courses.html
How to insert VBA code in Excel How to insert VBA code in Excel
Code
Sub add_new_sheet()
Dim sh As Worksheet, nsh As Worksheet
Dim nextdate As Date
Dim ndate As Date
Dim x As Integer
Dim startdate As Date
x = 1
Worksheets("Sheet1").Range("A1").Select
Worksheets("Sheet1").Range("A1").NumberFormat = ("dd-mmm-yyyy")
Worksheets("Sheet1").Range("A1").Value = Date
Cells.EntireColumn.AutoFit
startdate = Worksheets("Sheet1").Range("A1").Value
For x = 1 To 5
nextdate = startdate + x
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Range("A1").NumberFormat = ("dd-mmm-yyyy")
ActiveSheet.Range("A1").Value = nextdate
Cells.EntireColumn.AutoFit
ActiveSheet.Name = Format(nextdate, "dd-mmm-yyyy")
Next
End Sub
For more help visit my website http://www.easyexcelanswers.com or email me at [email protected].
Contact me regarding customizing this template for your needs.
Click for online Excel Consulting http://www.calendly.com/easyexcelanswers
I am able to provide online help on your computer at a reasonable rate.
https://www.amazon.com/shop/barbhende...
Check out my next one-hour Excel Webinar
https://www.crowdcast.io/easyexcelans...
I use a Blue condensor Microphone to record my videos, here is the link
https://amzn.to/37gyyGa
Check out Crowdcast for creating your webinars
https://app.linkmink.com/a/crowdcast/83
If you need to buy Office 2019 follow
https://amzn.to/2VX5dv8
I use Tube Buddy to help promote my videos
Check them out
https://www.Tubebuddy.com/easyexcelan...
Follow me on Facebook
Facebook: easyexcel.answers
TWEET THIS VIDEO Add a sheet tab for Every Day of the ...
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
http://www.youtube.com/timedtext_cs_p...
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.
6 سال پیش
در تاریخ 1397/07/08 منتشر شده
است.
44,064
بـار بازدید شده