Make Excel Update Links Using VBA
Using VBA can help us with a lot of things in Excel. It does not necessarily mean that the help means that the…
Category: vba
How to Get All Unique Values Using VBA
Working with VBA is used today mostly to automate processes. Sometimes, however, it can be easier to do the work itself in the…
How to Format Date in VBA
You are probably familiar right now with the fact that everything that can be done in Excel can also be done through VBA,…
How to Turn Screen Updating On and Off in VBA
If you ever worked with VBA, you could probably be in a situation where your code is not as fast as you would…
Create an Array of Sheets in VBA
To work with the arrays in VBA, you need to have an initial understanding of what are they all about. An array is…
How to Open CSV File in VBA
Although it is not strictly and directly defined, Excel relates to all other Office programs and file types. This is best visible and…
Break Long String to Multiple Lines in VBA
If you find any kind of problem or impediment in Excel and VBA, you will soon notice that there is always an easy…
How to Create Pi in VBA
Excel is a fantastic tool for all mathematical operations. On top of it, using VBA for these purposes can also be handy. In…
Find the Date in the Column with VBA
As already seen, VBA is a very effective tool that can be used to automate almost everything that we would usually need multiple…
Multiply Cells Using VBA
So far, you are probably aware of the good things and improvements in your daily activities that VBA can bring. When talking about…