The ‘used range’ property can be really useful but it has known bugs
Category: tips
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