Create Custom Commands for Excel - VBA

You can create Custom Commands for Excel to perform some predetermined operations. These commands can be entered directly inside a cell to do the required actions (calculations)

Please note that, these commands are made on VBA, so please refer our previous articles for the basic idea on Macros and VBA

Example Command : ADD

Command to ADD to values from columns A and B and display in C, the command “ADD” will be typed in cells of Column C

Steps :

What is $ (dollar) sign in excel formulas? $ sign can be used to make a cell value constant within a formula when you drag it to other cells