1/. This will handle "atm" in any row
2/. Doesn't the workbook I posted work for you?
It seems okay to me.
I just tested the uploaded file in case I had posted the workbook without saving the final version, and it seems to work.
3/. This code
Is used to calculate the number of days in the month of December, as this never varies I could have just used
I left it in to let you see why it is different from all the other months in this instance.
".Name" returns the sheet name (It is contained within the With Statement)
"YearToSet" is returned from the Input box.
When this is concatenated we get
e.g.
"1/January/2010" as a string
returns a date
This returns the next month based on the name of your worksheet.
We then subtract the two to get the number of days in any month.
Hope this helps
Bookmarks