Macros & Excel VBA Archives - Page 70 of 74

How to Insert Square Root Symbol in Excel (8 Easy Ways)

Oct 3, 2023

This article will show you how to insert the square root symbol in Excel. Sometimes you may need to store irrational numbers as data in an Excel ...

How to Insert Square Root Symbol in Excel (8 Easy Ways)

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

Feb 9, 2023

The process of copying worksheets is a very common phenomenon among excel users. Especially, when the dataset gets quite large, we tend to copy the ...

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

How to Auto Populate Date in Excel When Cell Is Updated

Oct 1, 2023

Sometimes, several people work on a worksheet and anyone can update the worksheet anytime. So, the worksheet owner might want to see the last updates ...

How to Auto Populate Date in Excel When Cell Is Updated

How to Convert Text to Numbers in Excel (8 Easy Ways)

Sep 21, 2023

Sometimes the numbers on your worksheet behave strangely; they don't carry out arithmetic operations as they ought to. This is because, despite their ...

How to Convert Text to Numbers in Excel (8 Easy Ways)

How to Highlight Every Other Row in Excel (3 Easy Methods)

Oct 2, 2023

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

How to Highlight Every Other Row in Excel (3 Easy Methods)

How to Delete Blank Rows in Excel (6 Ways)

Feb 15, 2023

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 Delete Blank Rows in Excel (6 Ways)

How to Use For Each Loop in Excel VBA (3 Suitable Examples)

Feb 16, 2023

A For Each Loop is a piece of code that handles repetitive tasks efficiently without using any repetitive coding blocks. In this article, we ...

How to Use For Each Loop in Excel VBA (3 Suitable Examples)

How to Use Do While Loop in Excel VBA (3 Examples)

Feb 11, 2023

When you would like to repeat a statement as long as the condition meets, you can use the do while loop in Excel VBA. Using the do while loop, you ...

How to Use Do While Loop in Excel VBA (3 Examples)

How to Use Do Until Loop in Excel VBA (with 2 Examples)

Sep 19, 2023

People like to be adventurous. They do not like to do the same thing again, again and again. In terms of working with VBA, we can skip the same code ...

How to Use Do Until Loop in Excel VBA (with 2 Examples)

Changing Case using Worksheet Functions and Excel VBA

Feb 12, 2023

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

Changing Case using Worksheet Functions and Excel VBA

How to Use For Next Loop in Excel VBA (10 Suitable Examples)

May 10, 2023

Are you looking for ways to use the VBA For Next loop in Excel? Then this is the right place for you. A loop is used when we need to run an ...

How to Use For Next Loop in Excel VBA (10 Suitable Examples)

IF & AND Functions in Excel VBA to Test Multiple Conditions

Feb 20, 2023

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

IF & AND Functions in Excel VBA to Test Multiple Conditions

How to Use Select Case Statement in Excel VBA (2 Examples)

Feb 9, 2023

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. This article ...

How to Use Select Case Statement in Excel VBA (2 Examples)

How to Use Table Reference with Excel VBA (20 Examples)

Feb 11, 2023

In Excel workbooks with large datasets, it can be convenient to refer to a table by its name instead of its whole range. Using VBA in Excel is the ...

How to Use Table Reference with Excel VBA (20 Examples)

How to Count Frequency of Text in Excel (4 Effective Ways)

Sep 24, 2023

Have you ever wondered how to count the frequency of text in Excel, i.e. the number of times a specific text appears in a range? In this article, we ...