How to Filter Excel Pivot Table using VBA
Excel offers a robust tool for filtering Pivot Tables with the VBA code. In this article, I’m going to show you different ways…
Category: vba
Saving XLSX File in Excel VBA
In Excel, you can save a file using the VBA code. You can do it by specifying the path and name of a…
Insert Double Quotes in a String in VBA
We can recognize a string in VBA when the value is inside double-quotes. Let’s how it works inside VBA editor. If you run…
Selecting a Range Using Variables
You can select a range in Excel using the range function: This code selects cells between columns B2 and E10. Selecting rows using…
Countifs VBA
The COUNTIFS function is a popular function if you want to count values for multiple conditions. It can also be used with VBA….
Conditional Formatting Based on Cell Color
If you want to use conditional formatting where a criterion is a cell color, you can’t just use standard conditional formatting. You have…
VBA If Then Else (complete guide)
Sometimes you don’t want every part of your code to be executed as you run your macro. In almost every computer language. In…
VBA Exit If Statement
If you operating with loops, there is a way you can leave the loop based on certain criteria. You can use Exit For…
Find and Replace in Header and Footer in Excel
If you want to replace text in Excel, you can go to Home >> Editing >> Find & Select >> Replace (Ctrl +…
VBA range.rows
The Rows property represents all the rows on the specified worksheet or range. We are going to use the following example. Each cell…