## How to Use For Each Next Loop in Excel VBA

We have already covered an introduction to looping and the simplest type of loop, the For…Next Loop in a previous tutorial. Let’s just remind ourselves of what a loop is: its code that handles...

We have already covered an introduction to looping and the simplest type of loop, the For…Next Loop in a previous tutorial. Let’s just remind ourselves of what a loop is: its code that handles...

We have already covered an introduction to looping and the simplest type of loops, namely the For…Next Loop and the For Each…Next Loop, in previous tutorials. We discovered that the For…Next Loop and the...

Sparklines are tiny mini-charts that are contained wholly within worksheet cells. Sparklines were introduced in 2010 and later versions of Excel. Sparklines allow for visualization of data and one can use sparklines to showcase...

Performing operations and calculations involving dates requires that one acquires familiarity with some of Excel’s Date and Time Functions. The DATEDIF worksheet Function in Excel calculates the difference between two dates that are given...

Conditional formatting allows one to visually highlight or visually emphasize certain values in one’s dataset, based on the fulfilment of a certain criteria. It can be time consuming to go through large data sets...

The Do Until Loop Structure is utilized, when one has a set of statements or actions to be repeated and repetition occurs until the condition evaluates to true, in other words, while the condition...

Excel provides the text worksheet functions, namely the Upper Function, the Lower Function and the Proper Function, which can change the case of a specified input text string. This text string could be entered...

Often when writing VBA code, one may need to repeat the same action or series of actions more than a couple of times. One could, in this case, write each action over and over...

Excel usage is widespread and Excel is often the go-to Office application for data entry, analysis, and manipulation. Microsoft Access provides relational database capability in a compact desktop environment. Fewer people use Access, even...

Excel provides functions to calculate the largest or maximum value in a range and also functions to calculate the smallest or minimum value in a range. The first function we are going to look...

We have already seen how to use the IF & AND worksheet Functions to test multiple conditions, in a previous tutorial. We are now going to see how to use the IF statement in...

One can implement conditional logic in VBA using an IF statement, multiple IF-Elseif statements or one can use the Select Case statement in order to implement conditional logic. In the case where one has...

The OR Function is a logical Function, that evaluates two or more conditions and returns true if at least one of the conditions is true. If all of the conditions are found to be...

It is often necessary to protect either the sensitive information in one’s actual worksheet or the workbook structure, from being edited. Excel provides different options for protecting and securing one’s data and we are...

We have already seen how to utilize the VLOOKUP Function in a previous tutorial. We are now going to see how to use the HLOOKUP Function. HLOOKUP stands for horizontal lookup and is used...

- Top 20 Advanced Essential Excel Skills You Need to Know
- 102 Microsoft Excel Formulas & Functions Cheat Sheet…
- Learn Excel VBA Programming & Macros [Free Tutorials,…
- How to Make a Frequency Distribution Table & Graph in…
- How to Reference PivotTable Data in Excel Formulas with…
- Excel 2013 Scenario Manager To Do Scenario Analysis
- How to Make FOR LOOP in Excel Using Formulas?
- Conditional Formatting in Excel 2013 [Multiple, Based on…
- What is active cell in Excel
- ActiveX Controls Excel [Check box, Combo box, List box, Text