WorkBooks and WorkSheets
Workbook->WorkSheet->Column->Row WorkBook stays at the top of the hierarchy. If we want to retrieve the value from a cell then we have to follow the hierarchy to reach to that particular cell. The Entire...
Category: Excel WorkBook
Introduction to Excel WorkBook
One complete Excel file is called as WorkBook. Now this is something interesting, for dealing with the WorkBook, in general we have two options By using ActiveWorkbook By Storing the instance of ActiveWorkbook to...
Add Tools to Quick Access Tool Bar(Excel Top Bar)
You can also add the “Commands” or “Tools” to “Quick Access Tool Bar” (top nav bar) in your excel sheet and it will be placed next to “Save” or “undo” icon in the excel...
Excel Macro – Visual Basic Editor
The first question will be where do we write the code , Open the Excel and then press “Alt+F11” and you will get the another window named as “Microsoft Visual Basic” and press “Alt+F11”...
VBA Codes – Record Macro
There are two most common ways to write VBA codes, they are- Record the MACRO. Write it in VBA Editor from scratch. Obviously it’s easy to record the Macro and use it but...
How to Enable Macro in Excel
Before we proceed, first and foremost thing to do is Enable the Macro in your Excel Main Menu -> Excel Options Trust Center->Trust Center Setting
Getting Started with Excel Macro
Excel Macro is a very effective tool. Once you get to know it, you can make wonders. Right from writing simple formulas to making complex applications and User forms, database connectivity or data structures....