“We can’t connect to” in Excel
"We can't connect to" pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are...
VBA ColorIndex
Colors Colors could be very important and useful in excel application. There are two ways in which you can...
VBA Formatting Cells
Learn to format cells using VBA.
VBA Select Method
Selection is a method in Excel VBA that performs an action. You use the Select method to select a single cell or...
Selections, Formatting Cells and Color (Color Index)
Majorly, all the programming or tasks you do in Excel requires you using Cells, or focuses on Cells, therefore, you need to...
Writing Your First Macro
Learning to write your first macro in excel is very exciting. In this tutorial we will write and run our first simple...
What is a Macro?
Macro is just the name given to the codes written in VBA. So our codes, henceforth, will be referred to as Macro.
Getting VBA setup in Excel
Setting up VBA does not require any special software installation. The VBA development software is included with each package of the Microsoft Office suite...
What is VBA in Excel?
VBA VBA, which stands for Visual Basic for Application, is a programming language developed to work with Microsoft’s...
