Macros & Excel VBA

How to insert square root symbol in Excel (7 easy ways)

In this article, I will narrate how to insert square root symbol in Excel. The square root is one of the most used symbols in Excel. I will ...

How to Copy a Worksheet in Excel (5 Smart Ways)

In Excel, there are many ways to copy a worksheet in the same or different workbook. In this article, we will see many processes on how to copy a ...

How to auto populate date in Excel when cell is updated

In this article, I will show you how to auto-populate date in Excel when a cell is updated. I will show the whole process using Excel VBA. I will ...

How to Convert Text to Numbers in Excel

In this article, I tried to sum up some of the processes on how to convert text to numbers in Excel. In many cases when you import data from an ...

How to Highlight Every Other Row in Excel

In this article, we will see how to highlight every other row in Excel. Some available techniques are applying conditional formatting, using ...

How to Generate Random Numbers in Excel (9 Unique Methods)

Random numbers are those numbers that are generated by a process in which the outcome is not predictable and in a defined interval/set, the values ...

How to Delete Blank Rows in Excel (6 Ways)

While working with a big spreadsheet you often insert blank rows intentionally to read and understand it properly. Although inserting blank rows are ...

How to Use the 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 ...

How to Use the Do While Loop in Excel VBA

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 ...

How to Use Do Until Loop in Excel VBA

The Do Until Loop in Excel VBA is utilized, when one has a set of statements or actions to be repeated and repetition occurs until the condition ...

Changing Case using Worksheet Functions and Excel VBA

Excel provides the text worksheet functions, namely the Upper Function, the Lower Function, and the Proper Function, which can change the case of a ...

For Next Loop in VBA Excel (How to Step and Exit Loop)

In this article, I shall discuss at first how to use For Next Loop in Excel VBA. Then I will elaborate on the discussion on how to exit a For Loop ...

IF & AND Functions in Excel VBA to Test Multiple Conditions

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 ...

How to Use the Select Case Structure in Excel VBA

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 ...

Using Table Nomenclature in Excel & Referring to Tables in VBA!

We have already covered how to format Excel Tables extensively in a previous tutorial. We are now going to look at using Table Nomenclature or ...

ExcelDemy
Logo