Downloads

Merge Workbooks (1.4 KiB, 355 hits)

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

Print hidden sheets only (472 bytes, 130 hits)

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

Print Visible Sheets (336 bytes, 117 hits)

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

Yearly Calendar Template (82 KiB, 362 hits)

Excel Workbook – a macro driven yearly calendar template … More

LookupAddress.txt (329 bytes, 192 hits)

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

Monthly Calendar Template (62.5 KiB, 380 hits)

Excel Workbook – a macro driven monthly calendar template … More

Isleap Function (420 bytes, 135 hits)

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

WeekDayText Function (562 bytes, 165 hits)

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

GenNumbers Macro (1023 bytes, 156 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.

Excel Digest