Sometimes you do not know the number of elements in an array before runtime. In most other programming languages, working with arrays and adding and deleting elements is easy. In VBA, this is not the case. However, there is a simple solution to dynamically populate arrays, with the ReDim statement. … Read more

Sending emails via VBA can be very useful. You can create powerful Excel macros, which help you automate your tasks and do your job faster and more efficiently. In this guide, I will show how to create a simple Excel macro with VBA, which you can use to send emails … Read more