Power Spreadsheets

VBA Code Generator and Coding Tools

Affiliate Disclosure This Post focuses on AutoMacro, one of my favorite VBA-related tools. In the following sections, I: Describe the main reasons that explain why I find AutoMacro useful and believe most macro/VBA users have the potential to benefit from AutoMacro; and Explain/introduce AutoMacro's main tools/features. Use the following Table of Contents to navigate to … [Read more...]

Excel IFERROR, ISERROR, ISERR, IFNA and ISNA Functions Tutorial: Step-by-Step Guide and 14 Examples to Handle Errors and Use IS Functions in Formulas

In this Excel IFERROR, ISERROR, ISERR, IFNA and ISNA Tutorial, you learn how to use the IFERROR, ISERROR, ISERR, IFNA and ISNA functions in your worksheet formulas for the following: Identify errors, including the #N/A error. Handle errors, including the #N/A error, and return a specific: Value; Formula; Expression; or Reference. Carry out VLookups that handle … [Read more...]

Excel VBA Last Row and Last Column: Step-by-Step Guide and 20 Examples to Find the Last Row or Column with Macros

In this VBA Tutorial, you learn how to find the last row or column with macros. This VBA Last Row or Last Column Tutorial is accompanied by an Excel workbook containing the data and macros I use in the examples below. You can get immediate free access to this example workbook by subscribing to the Power Spreadsheets Newsletter. Use the following Table of Contents to … [Read more...]

Excel VBA Font: Step-by-Step Guide and 15 Examples to Change or Set a Cell Range’s Font Characteristics with Macros

In this VBA Tutorial, you learn how to change or set the font characteristics of a cell range. This VBA Font Tutorial is accompanied by Excel workbooks containing the data and macros I use in the examples below. You can get immediate free access to these example workbooks by subscribing to the Power Spreadsheets Newsletter. Use the following Table of Contents to … [Read more...]

500+ Excel Resources: The Epic Power Spreadsheets Resources List

My main purpose at Power Spreadsheets is to help you become an Excel Power User. I work (and will continue to work) very hard to achieve this purpose. However, Excel is a massive topic. Therefore, I'll probably won't be able to cover absolute everything about Excel. I'm also aware that I don't have all the answers. I'm constantly learning new things about Excel. This … [Read more...]