Using Worksheet Change Event To Run Macro When any Change is Made

If you are here, its probably you want to learn how to run a subroutine every time a change is made in a specific sheet. This article will teach exact...

The blue boxes represents 11th classes's statistics in all three subjects. The orange boxes are for 12th class to show the same statistics.   ...

test new

'***--------------------Main Sub-------------------------*** Sub SplitIntoSheets()With Application .ScreenUpdating = False .DisplayAlerts = False ...

Forecast Vs Actual Variance Calculation in Excel

Forecasting is a major part of any business management task. And the comparison of actual and forecasted outcomes is critical in every project. Ha...

How to Calculate Number of Days in Microsoft Excel

In this article, we will learn How to Calculate Number of Days in Microsoft Excel. How can you calculate days between two dates ? There coul...

The Double Negatives (--) in Excel

You must have seen these strange -- (double negative) signs in some advance formulas. If you try removing them from the formula, the formula stops wor...

Allow Input if Adjacent Cell Contains Specific Text in Excel

In this article, we will learn how to allow any input in a cell if adjacent cell contains a specific text in a adjacent cell in Excel. We will be usin...

Terms and Conditions of use

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.