Format Date in Header or Footer in Excel
The date in the header and footer of an Excel file repeats at the top or bottom of each printed page. It helps…
Category: vba
How to Add Sheet at the End of All Sheets in VBA
Excel VBA is a great tool for manipulating everything that is in your sheets. It is also a great way to manipulate the…
How to Clear Range in Excel VBA
With VBA, you can always create a code that will automatically do certain actions, write something in your sheet, create another sheet or…
How to Use Toggle Button in VBA
Visual Basic for Application (VBA) is a useful tool for automating the processes and work itself in Excel. There are a lot of…
How to Set Excel Cell Value to Variable in VBA
In VBA, there are multiple ways to select and assign a value for a certain cell. There are also a couple of ways…
How to Find Column Index in VBA
When we talk about Excel and VBA, one of the most important things is to be able to position ourselves and find the…
How to Check If an Array Is Empty in VBA
When dealing with arrays in VBA, you must realize that there are two different types, and that is static and dynamic. Static arrays…
Select Range Based on a Variable using VBA
Selecting the data that we want to manipulate and work with is often the first step in the process of conducting the actual…
How to Select a Range of Columns in VBA
Visual Basic for Applications (VBA) can be used for virtually everything that we want. When you start working with it, you simply cannot…
Select Column in Table Using VBA
VBA is, as you are probably aware by now, a great tool for the automation of work in Excel. It can be used…