Category Archive for "Excel"

How to Avoid Using Select in Excel VBA

Understanding the Problem If you've been working with Excel VBA, you might have heard about the negative impact of using the Select function. Although it might seem convenient at...

Find last used cell in Excel VBA

When working with Excel VBA, it is common to need to find the last used cell in a range. This is useful for a variety of purposes, such as dynamically resizing arrays or performing...