Although not used very often on this site you might find yourself in a situation where you want to use the Do Until Loop in Excel VBA. Code placed between Do Until and Loop will be repeated until the part after Do Until is true.
Read article
This example shows you how to count blank and nonblank cells in Excel.
October 11, 2024
Use the Quick Analysis tool in Excel to quickly analyze your data. Calculate totals quickly insert tables, apply conditional formatting, and more.
October 11, 2024
Use the IRR function in Excel to calculate a project's internal rate of return. The internal rate of return is the discount rate that makes the net present value equal to zero.
October 11, 2024
If you are not familiar with Error Handling yet we highly recommend you to read this example first. When an error in Excel VBA occurs the properties of the Err object are filled with information.
You can sort your Excel data by one column or multiple columns. You can sort in ascending or descending order. To sort by one column execute the following steps.
You can use a RefEdit control in Excel VBA to get a range from a user. The Userform we are going to create colors the minimum value of the range stored in the RefEdit control.
Below we will look at a program in Excel VBA that deletes blank cells.
This page teaches you how to convert an Excel file to a PDF file. 1. Open a workbook. 2. On the File tab click Save As. 3. Click Browse. 4. Select PDF from the drop-down list.
This article shows you how to create a meal planner in Excel. Here's what we are trying to achieve:
Below we will look at two programs in Excel VBA. One program loops through all charts on a sheet and changes each chart to a pie chart. The other program changes some properties of the first chart.
Use the 'Insert Hyperlink' dialog box in Excel to create a hyperlink to an existing file a web page or a place in this document. You can also use the HYPERLINK function.
The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial statistical and engineering data analysis.
Calculating percentages in Excel is easy. Percentage simply means 'out of 100' so 72% is '72 out of 100' and 4% is '4 out of 100' etc.
This example illustrates the ISERROR function in Excel. The ISERROR function checks whether a value is an error and returns TRUE or FALSE.
Use the INDIRECT function in Excel to convert a text string into a valid reference. You can use the & operator to create text strings.
Learn all about Excel's lookup & reference functions such as VLOOKUP HLOOKUP MATCH INDEX and CHOOSE.
This article teaches you how to reverse the order of a list in Excel. For example we want to reverse the list in column A below.
A quadratic equation is of the form ax2 + bx + c = 0 where a ≠ 0. A quadratic equation can be solved by using the quadratic formula. You can also use Excel's Goal Seek feature to solve a quadratic equation.
Below we will look at a program in Excel VBA that counts the number of words in a selected range. One or more spaces are assumed to separate words.
Insert a page break in Excel to specify where a new page will begin in the printed copy. To insert a horizontal page break execute the following steps.
Use the shortcut F12 to display the Save As dialog box in Excel. Press CTRL + s to save an existing workbook. It's good practice to periodically save while you are working on your Excel file.
To find the closest match to a target value in a data column use INDEX MATCH ABS and MIN in Excel. Use the VLOOKUP function in Excel to find an approximate match.
This page teaches you how to apply a date filter in Excel to only display records that meet certain criteria.
When we format cells in Excel we change the appearance of a number without changing the number itself. We can apply a number format (0.8 $0.80 80% etc) or other formatting (alignment font border etc).
The difference between a function and a sub in Excel VBA is that a function can return a value while a sub cannot. Functions and subs become very useful as program size increases.
Use the IFERROR function in Excel to return an alternative result such as text when a formula evaluates to an error. For example Excel returns the #DIV/0! error ...
Use the If Then statement in Excel VBA to execute code lines if a specific condition is met.