Page 18 of 29 · 695 articles
Learn more about the Workbook and Worksheet object in Excel VBA. In Excel VBA an object can contain another object and that object can contain another object etc. In other words Excel VBA programming involves working with an object hierarchy. This probably sounds quite confusing but we will make it clear.
To calculate a weighted average in Excel simply use SUMPRODUCT and SUM.
If you use an Excel macro frequently you can add it to the Quick Access Toolbar. This way you can quickly access your macro. First we record an empty macro.
Use the solver in Excel to find the maximum flow from node S to node T in a directed network. Points in a network are called nodes (S A B C D E and T). Lines in a network are called arcs (SA SB SC AC etc).
Below we will look at a program in Excel VBA that removes duplicates.
The Offset property in Excel VBA takes the range which is a particular number of rows and columns away from a certain range.
Instead of creating an Excel workbook from scratch you can create a workbook based on a template. There are many free templates available waiting to be used.
Below we will look at a program in Excel VBA that imports sheets from other Excel files into one Excel file.
Sometimes multiple conditional formatting rules in Excel conflict. A higher rule always wins. This example illustrates two different results.
Most chart types have two axes: a horizontal axis (or x-axis) and a vertical axis (or y-axis). This example teaches you how to change the axis type add axis titles and how to change the scale of the vertical axis.
Wrap text in Excel if you want to display long text on multiple lines in a single cell. Wrap text automatically or enter a manual line break.
Sensitivity analysis gives you insight into how the optimal solution changes when you change the coefficients of the model. After the Excel solver found a solution you can create a sensitivity report.
This page illustrates useful find features in Excel. Learn how to perform workbook-wide searches case-sensitive searches find exact cell content and use wildcards.
The AND function in Excel evaluates multiple conditions and returns TRUE only if all conditions are TRUE. This guide provides a comprehensive understanding of the AND function starting with basic usage and progressing to more advanced formulas.
This article teaches you how to randomize (shuffle) a list in Excel. For example let's randomize the list in column A below.
The IF function in Excel checks whether a condition is met and returns one value if true and another value if false. This page contains many easy to follow IF examples.
This example teaches you how to import data from a Microsoft Access database. In Excel when you import data you make a permanent connection that can be refreshed.
Below we will look at a program in Excel VBA that solves a small instance of a knapsack problem.
This example illustrates the difference between A1 R1C1 and R[1]C[1] style in Excel VBA.
Instead of multiple If Then statements in Excel VBA you can use the Select Case structure. Let's explore this through two examples.
A text box is an empty field where a user can fill in a piece of text. To create a text box in Excel VBA execute the following steps.
This example illustrates the End property of the Range object in Excel VBA. We will use this property to select the range from the Active Cell to the last entry in a column.
This example teaches you how to create a Pareto chart in Excel. The Pareto principle states that for many events roughly 80% of the effects come from 20% of the causes.
This example teaches you how to use PERCENTILE and QUARTILE in Excel. Below you can find a list of scores.