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