Visual Basic for Applications

Learn Excel – “Show AutoFilter Selected Items”: Podcast #1827

               

Mark G has an AutoFilter outside the print range and wants to show what is selected in the AutoFilter inside the print range. Excel 2013 Table Slicers could do this, but Back

Learn Excel – “Is Text in ANY Column?”: Podcast #1826

               

Two similar questions: (1) Can I count how many Rows contain certain Text in any Column? (2) Can I Filter to only Rows that have the selected Text in Back

Learn Excel – “Create an Invoice Register”: Podcast #1808

               

This follow-up video – Episode #1808 – to previous Episode #1505 shows how to automatically create Back

Learn Excel – “Hide Blank Rows” – Podcast #1738

               

Preserve ‘Undo’, Show All and Hide Blanks: “Go!”

Learn Excel – “Hide Blank Rows with Event Handler” – Podcast #1737

               

How to work with unseen Event Handlers and Worksheet Change Events…

Learn Excel from MrExcel