Site Search


Set specific user with column user-type
Forum Q&A: Hi All, 1. I add a new column and name. My new column name is User-type and custom_field: ...
Subroutine Works but I get a Run Time Error 13
Forum Q&A: I'm a vba novice but working on it... I have a subroutine within the "Names" worksheet tha...
How can an excel 2007 file be renamed to 9AE322A2.tmp and Why should this happen?
Forum Q&A: Hi everybody,I use MS Excel 2007 since last several years and I have an important excel fi...
Simple Excel Function to Combine Values in All Versions of Excel - UDF
: Excel function that combines values from multiple cells or inputs using a delimiter - work...
Make All Numbers in a List Positive in Excel
Tutorial: Take a list of numbers and make them all positive, regardless of whether the list contain...
Countdown Timer in Excel
Tutorial: How to create a countdown timer in Excel. This allows you to display a timer in whatever ...
Returning to last active sheet after a macro automatically runs
Forum Q&A: I have made an excel workbook for my trading , it has lots of sheets and each sheet has a...
Make All Text Upper Case or Lower Case in Excel
Tutorial: How to quickly change all text to upper case or lower case in Excel.  This allows you to ...
Excel Prank - Random Cell Selection
Tutorial: Excel prank where a random cell is selected each time a user tries to select a cell. For i...
Excel Prank - Hide Text on Cell Selection
Tutorial: This prank will hide the contents of the currently selected cell and then show the content...
StartRow argument ignored when importing a .csv
Forum Q&A: Hello, I'm following the "Automated Text Import in Excel with File Selection - The Easy Wa...
Upgraded to Windows 10 and now Excel Macros Don't Work
Forum Q&A: Hello! Our company IT Department recently upgraded all of our computers to Windows 2010 an...
Linking Cells in Excel
Tutorial: In this tutorial I am going to cover how to link cells together. This is a useful feature ...
Create and Manage Tables in Excel
Tutorial: Here, I'll show you everything you need to know to get started using tables in Excel; how...
Insert Check Mark in Excel - 3 Ways - Incl. VBA and UDF
Tutorial: This tutorial goes beyond other simple check-mark tutorials. Here, I'll show you 3 methods...
Odd or Even Row Formulas in Excel
Tutorial: Formulas to determine if the current cell is odd or even; this allows you to perform speci...
Referencing different WB
Forum Q&A: https://www.teachexcel.com/excel-tutorial/input-form-to-get-data-and-store-it-in-another-t...
Excel Forum