Apple iOS shortcut to automate text extraction from your screen…
Category: macro
How to load RunKeeper workouts into Apple Health using Shortcuts
What you will need: Your RunKeeper data that you can get here. Scriptable installed on your iPhone. Microsoft Excel. The … 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