What you will need: Your RunKeeper data that you can get here. Scriptable installed on your iPhone. Microsoft Excel. The … More
Category: micromacros
How to convert a CSV to JSON
I have recently started using the iOS’s Shortcuts and while trying to do more I have also started to use … More
How to create a custom ribbon for your Excel add-in
Ribbons are a customisable and simple way to have a more professional looking add-in
How to create a toolbar for your Excel add-in on installation
The good enough and the better way
Getting the actual used range of a sheet
The ‘used range’ property can be really useful but it has known bugs
Improving range browsing performance
Sometimes it’s necessary to browse through all of the cells in a sheet and using ranges can kill your code performance.
Make your macros shorter – IIf
Using “IIf” can make your macros shorter but be careful with code readability and maintenance