Downloads

  Merge Workbooks (1.4 KiB, 955 hits)

VBA code – a macro to merge two workbooks into a new one … More


  Print hidden sheets only (472 bytes, 332 hits)

VBA code – a macro to print only hidden sheets in the active workbook … More


  Print Visible Sheets (336 bytes, 330 hits)

VBA code – a macro to print only visible sheets in the active workbook … More


  Yearly Calendar Template (82.0 KiB, 821 hits)

Excel Workbook – a macro driven yearly calendar template … More


  LookupAddress.txt (329 bytes, 446 hits)

VBA code – a function to return the address of a lookup value … More


  Monthly Calendar Template (62.5 KiB, 749 hits)

Excel Workbook – a macro driven monthly calendar template … More


  Isleap Function (420 bytes, 280 hits)

VBA code – a function to decide whether a year is leap or not … More


  WeekDayText Function (562 bytes, 347 hits)

VBA code – a function to return the day of the week in text (name of the day) … More


  GenNumbers Macro (1,023 bytes, 378 hits)

VBA Code – a macro to generate a list of random numbers … More


Note: Each one of these files has a corresponding post in the blog which elaborates on its functionality and uses.