VBA

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 – “Hide Blank Rows Without a Macro” – Podcast #1736

               

Hide & Seek – without a Macro!

Learn Excel from MrExcel