Read Data from a Text File using Excel VBA
Below we will look at a program in Excel VBA that reads data from a text file. This file contains some geographical coordinates we want to import into Excel.
How to use Excel
Learn how to use Excel like a pro with easy-to-follow tutorials and tips — spreadsheets, charts, pivot tables, and macros.
ROWS: 506UPDATED: OCT 2024SECTION: 01 · PAGE 12/22
October 9, 2024
Type Mismatch Error in Excel VBA
The type mismatch error in Excel VBA occurs when you try to assign a value to a variable that isn't of the correct type.
Scatter Plot in Excel
Use a scatter plot (XY chart) to show scientific XY data. Scatter plots are often used to find out if there's a relationship between variables X and Y.
Mod Operator in Excel VBA
The Mod operator in Excel VBA gives the remainder of a division. This page starts with some simple examples.
What-If Analysis in Excel
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. The following example helps you master what-if analysis quickly and easily.
Events in Excel VBA
Events are actions performed by users which trigger Excel VBA to execute code.
Reverse Strings in Excel VBA
Below we will look at a program in Excel VBA that can reverse strings.
Frequency Distribution in Excel
Did you know that you can use pivot tables to easily create a frequency distribution in Excel? You can also use the Analysis Toolpak to create a histogram.
Regression Analysis in Excel
This example teaches you how to run a linear regression analysis in Excel and how to interpret the Summary Output.
List of Holidays in Excel
This example teaches you how to get the date of a holiday for any year (2024 2025 etc). If you are in a hurry simply download the Excel file.
Capital Investment in Excel
Use the solver in Excel to find the combination of capital investments that maximizes the total profit.
Quick Access Toolbar in Excel
If you use an Excel command frequently you can add it to the Quick Access Toolbar. By default the Quick Access Toolbar contains four commands: AutoSave Save Undo and Redo.
Sum Every nth Row in Excel
This example shows you how to create an array formula that sums every nth row in Excel. We will show it for n = 3 but you can do this for any number.
Cell References in Excel
Cell references in Excel are very important. Understand the difference between relative absolute and mixed reference and you are on your way to success.
Prevent Duplicate Entries in Excel
To prevent duplicate values from being entered into Excel use data validation and the COUNTIF function.
Print Titles in Excel
You can specify rows and columns in Excel that will be printed on each printed page. This can make your printed copy easier to read. To print titles execute the following steps.
Loop through Defined Range in Excel VBA (For Each Cell in Range)
Below we will look at a program in Excel VBA that loops through a defined range. For example when we want to square the numbers in the range A1:A3.
How to use the Excel ROW function
The ROW function in Excel returns the row number of a reference. For example =ROW(C4) returns 4. The ROW function can be quite useful.
How to use the Excel SORT function
Use the magic SORT function in Excel 365/2021 to sort your Excel data by one column or multiple columns. Let's give it a try.
Data Tables in Excel
Instead of creating different scenarios you can create a data table to quickly try out different values for formulas. You can create a one variable data table or a two variable data table in Excel.
Year Occurrences in Excel VBA
Below we will look at a program in Excel VBA that counts the number of year occurrences.
Most Frequently Occurring Word - Excel Formula
This example teaches you how to find the most frequently occurring word in Excel.
EVEN and ODD in Excel
Use EVEN and ODD in Excel to round numbers. Use ISEVEN or ISODD in Excel to determine if a number is even or odd.
How to Divide in Excel - Easy Formulas
There's no DIVIDE function in Excel. Simply use the forward slash (/) to divide numbers in Excel. Don't forget always start a formula with an equal sign (=).