Clear all borders using VBA
last update: July 12, 2016Display sheetname in cell formula
25 viewsExcel Diet: Reduce file size of excel workbook (2003 & older only)
122 viewsSelect all visible sheets in a workbook
139 viewsHide zero value lines within a pivot table in Excel 2003/XP/2000/97
27 viewsUse a ‘check’ symbol in Excel
95 viewsMacro to sort sheets in a workbook
46 viewsRound a figure to the nearest / highest 10,100,500 etc.
43 viewsUpdate all pivot tables in a workbook
35 viewsSimple loop trough rows..
60 viewsLoop through sheets macro