Latest Blog Posts - Page 64 of 584

Excel Convert Timestamp to Time (4 Easy Ways)

Jun 11, 2024

Download Practice Workbook Converting Timestamp to Time.xlsm Method 1 - Convert Timestamp to Time Using Combination of TIME and MID ...

Excel Convert Timestamp to Time (4 Easy Ways)

How to Insert an Excel Table from an Image

May 13, 2024

We will add a table from the below image for the methods below. Method 1 – Using an Image Saved in File Explorer Steps: Select a ...

How to Insert an Excel Table from an Image

Excel VBA to Check If String Contains Letters: 3 Easy Ways

Jul 7, 2024

Method 1 - VBA Code to Check If String Contains Any Letter Every character has a unique ASCII code and the computer recognizes them with that code. ...

Excel VBA to Check If String Contains Letters: 3 Easy Ways

Excel Formula to Change Cell Color Based on Text (3 Easy Methods)

Jun 22, 2024

Suppose you have the following dataset: Method 1 - Applying Conditional Formatting Steps: Application of Cell Rules Select the ...

Excel Formula to Change Cell Color Based on Text (3 Easy Methods)

How to Use Excel VBA Try Catch – 3 Examples

Aug 2, 2024

In the image below, the error is neglected by declaring the On Error Resume Next statement, which replicates the Try Catch statement. ...

How to Use Excel VBA Try Catch – 3 Examples

Else Without If Error VBA in Excel (3 Reasons with Solutions)

Nov 11, 2025

Not only in VBA, the If-Else-if condition is a widely popular conditional tool to investigate the conditions and then carry out tasks. This effective ...

Else Without If Error VBA in Excel (3 Reasons with Solutions)

Excel VBA Nested If Then Else in a For Next Loop (3 Examples)

Aug 4, 2024

In this article, we will explore three simple examples that demonstrate the practical application of nested If Then Else statements within a For Next ...

Excel VBA Nested If Then Else in a For Next Loop (3 Examples)

How to Use Excel VBA Do While Loop with Multiple Conditions

Jun 16, 2024

The Do While loop in Excel VBA allows code to be executed repeatedly as long as a specified condition remains true. In this article, we will explore ...

How to Use Excel VBA Do While Loop with Multiple Conditions

How to Create Excel Floating Total Row (2 Quick Ways)

Nov 11, 2025

In this article, I am sharing with you how to create Excel floating total row with a running total. Creating a floating row with a running total in ...

How to Create Excel Floating Total Row (2 Quick Ways)

Excel VBA to Filter Pivot Table Based on List

Jul 24, 2024

We will use Excel VBA to filter a Pivot Table based on a list. Consider the following dataset with fruit sales. Create a Pivot Table in ...

Excel VBA to Filter Pivot Table Based on List

How to Make Slicer Horizontal in Excel

Jul 6, 2024

Excel slicer is a vital tool that gives users easy access to data filtering and interaction. Slicers are often shown vertically, however, a ...

Using Excel VBA to Change the Pivot Table Source – 2 Methods

Aug 10, 2024

The dataset contains Product ID, Product, category, sales of the products, Date, and Outlets of a grocery shop. Method ...

Using Excel VBA to Change the Pivot Table Source – 2 Methods

Excel VBA Variable Types

Nov 11, 2025

In this article, we will discuss Excel VBA variable types. Variables are a fundamental concept of any programming language. Different types of data ...

How to Use Excel VBA to Filter a Pivot Table (5 Examples)

Jul 6, 2024

Method 1 - Filter a Pivot Table Based on Single Criteria Using VBA STEPS: To create a pivot table, a sample code is given ...

How to Use Excel VBA to Filter a Pivot Table (5 Examples)

How to Use Excel VBA to Call Private Sub from Userform

Nov 11, 2025

Looking for ways to use Excel VBA to call private sub from userform? Then, this is the right place for you. In Excel VBA, private subs are ...