Question Time – Excel VBA – How To Duplicate Rows Then Adjust Duplicates
Question Time How Do I Insert Duplicates Rows With VBA in A list and Alter The Duplicates? A reader needed a VBA routine to loop over financial data in...
- Posted February 3, 2016
How To Filter Data In LibreOffice Calc Using The Advanced Filter
How To Filter Data In LibreOffice Calc Using The Advanced Filter LibreOffice is a free and open source cross platform (Windows, Mac and Linux) Office software application that is...
- Posted January 4, 2016
Code Execution Has Been Interrupted – How To Fix That Annoying VBA Error
Code Execution Has Been Interrupted – The best fix to this Excel VBA Problem I first came across this Microsoft Excel vba error back in 2009, when the vba...
- Posted January 3, 2016
How To Enable The Developer Ribbon In Excel
How To Enable The Developer Ribbon In Excel You want to start using macros or visual basic for applications in Excel, but you can’t find the developer menu! You...
- Posted November 19, 2015
VBA Class Module Example – Better VBA With Objects
What is object based coding in VBA? Learn what VBA Class Modules are used for, and how to massively improve your vba by writing your own custom classes.
- Posted October 27, 2015
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...
- Posted April 30, 2015