Let's say you are trying to create a school management system. Here, you will have different types of variables like student name, student roll no, cl...
The functions like VLOOKUP, COUNTIF, SUMIF are called worksheet functions. Generally, the functions that are predefined in Excel and rea...
As we all know, whenever we make changes in a source data of a pivot table, it doesn't reflect immediately in the pivot table. We need to refresh ...
Many times we want to do some predefined and repetitive steps before the workbook closes. For example, closing connections to the database, deleti...
Macro Dialog Box is used to run, edit, assign shortcuts or delete a macro in open workbooks. To open a Macro dialog in Excel we can use the s...
Ok! This one is important. Any good VBA procedure always has this line mentioned at the beginning. Application.Screenupdating=FALSE And bef...
Excel does not provide any default function that converts a number or amount in words in Indian rupees or any currency. But it doesn't mean that w...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
