Thread: [Solved] Auto Populate Sheets?
View Single Post
 
Old 07-27-2018, 08:13 AM
ShankedS ShankedS is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Oct 2014
Posts: 62
ShankedS is on a distinguished road
Default

@NoSparks

Hmm. Well, technically I have Office 365 at home and Office 2007 at work, so I'm not sure why I set it to Office 2010.


Code:
yr = Application.InputBox("Enter 4 digit year from 2018 to 2025", "Create Sheets For Entire Year", Year(Date + 365), , , , , 1)
So what's going on here, exactly? You mention you set the date to January 6th, 2018, but changed that to:


Code:
endDate = DateSerial(2018, 7, 7)  'end of first pay period for 2019: 7/07/2018
However, it still goes Jan -> December. Though now that I look at it, that sets the endDate, not startDate. So I'm still not sure how startDate is set.

Last edited by ShankedS; 07-27-2018 at 12:35 PM.
Reply With Quote