How to Use R1C1 Reference Style in Excel?
In Microsoft Excel, we have two different types of reference styles. By default, the reference style that everybody uses is the A1 reference style while… Read Article
Workbooks Collection in VBA – Workbook Object
Today we will learn a very useful topic which is to use workbooks with the help of VBA in Excel. Workbooks come with their methods… Read Article
Optional Arguments in VBA – Usage with Examples
Today, we will learn to use VBA to use the Optional Arguments in a Function or a Sub Procedure. Arguments are used to supply the… Read Article
Object Browser in VBA
Today we will learn an important topic which is using the Object Browser in VBA. It is very important to learn and is helpful for… Read Article
Active Cell VBA – Properties and Methods
Active Cell refers to the cell that is currently active at the moment. The ActiveCell Object in VBA is used to refer to the Active… Read Article
Personal Macro Workbook VBA- Create and Use
In the previous article, we learned how to use Sub Procedures in VBA. Today we will learn to use the Personal.xlsb file which is the… Read Article
Change Cell Alignment Using VBA
We already know how to change the text alignment of cells in excel. Today we will learn how to change the horizontal as well as… Read Article
Lock Cells using VBA
Today we will learn an important functionality to lock Cells using VBA for editing. We will learn how to lock only the cells that contain… Read Article
How to Import, Export and Copy Module in VBA?
In the previous article, we learned the usage of Modules in VBA. Today, we will learn another important functionality to import and export the VBA… Read Article
Change the Background Color of Cells using VBA
Today, we will learn the important functionality of formatting the cells using VBA. We will change the background color of the cell or range with… Read Article
Employee Joining User Form – VBA Project Excel
Today, we will make a User Form using VBA in Excel. This is a project and is very interesting to learn. UserForms make Data Entry… Read Article
Insert Columns using VBA in Excel
In the previous article, we learned to insert new rows in a spreadsheet using VBA. Today we will learn to insert columns in spreadsheets with… Read Article