How to use Class Modules in Excel VBA, check out the video tutorial then the article for some extra depth. Get VBA Class Module Spreadsheet Here Also get updates when new blog or video tutorials are released. Submitting... VBA Class Modules - Some … [Read more...] about VBA Class Module Example – Better VBA With Objects
All Articles
How To Fill Empty Cells In Excel With Values Above
You have a spreadsheet with information missing because it was summarised for viewing as a report, but this format is no good for data analysis. You know you want to fill the empty cells with values, but how do you do it quickly? Perhaps you copied data from a report somewhere, and some columns were summarised with blank spaces sorta like the spreadsheet below. As you … [Read more...] about How To Fill Empty Cells In Excel With Values Above
Would you like to know how the web works?
I knocked this info graphic together as a high level overview of how the web works and more specifically how websites work to give you a big picture idea on how the individual parts of web technology fit together. So let me take you through the graphic. … [Read more...] about Would you like to know how the web works?
Mac Smart Folders Can Help Keep You Sane
The step by step tutorial to get you up and running and super productive with mac smart folders real fast. The Problem Maybe you have come across this issue before. You are building up notes or are creating articles for future blog posts and you want to categorise them. … [Read more...] about Mac Smart Folders Can Help Keep You Sane
Excel Advanced Filter – Criteria to Show Blank Cells
Today I had a problem in Excel that crops up quite often, namely how to filter to find blank cells or how to filter to exclude blank cells. … [Read more...] about Excel Advanced Filter – Criteria to Show Blank Cells