Browsed by
Month: May 2012

Creating a mini calendar inside an excel spreadsheet

Creating a mini calendar inside an excel spreadsheet

Whilst creating various turn-around-time reports, I thought it would be helpful to add a little calendar to the spreadsheet.  Here is an excel vba function that adds a mini calendar to the cell address you specify: Public Function MakeCalendar(intStartRow As Integer, intStartCol As Integer, strStartDate As String, strEnddate As String) As Boolean ‘Takes start row and column and prints a calendar. By Eric Ainsworth – www.synapsonic.com On Error GoTo Errorhandler Dim WeekDays() As String ‘little array for S-Sat WeekDays =…

Read More Read More