Downloads

  Merge Workbooks (1.4 KiB, 484 hits)
You need to be a registered user to download this file.

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

---

  Print hidden sheets only (472 bytes, 201 hits)
You need to be a registered user to download this file.

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

---

  Print Visible Sheets (336 bytes, 206 hits)
You need to be a registered user to download this file.

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

---

  Yearly Calendar Template (82.0 KiB, 495 hits)
You need to be a registered user to download this file.

Excel Workbook – a macro driven yearly calendar template … More

---

  LookupAddress.txt (329 bytes, 282 hits)
You need to be a registered user to download this file.

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

---

  Monthly Calendar Template (62.5 KiB, 483 hits)
You need to be a registered user to download this file.

Excel Workbook – a macro driven monthly calendar template … More

---

  Isleap Function (420 bytes, 191 hits)
You need to be a registered user to download this file.

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

---

  WeekDayText Function (562 bytes, 222 hits)
You need to be a registered user to download this file.

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

---

  GenNumbers Macro (1,023 bytes, 236 hits)
You need to be a registered user to download this file.

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.