Power Spreadsheets

In this VBA Tutorial, you learn how to convert strings to numbers of the Byte, Integer, Long, Single, Double, Currency and Decimal data types. This VBA Tutorial is accompanied by an Excel workbook containing the macros, data and formulas I use in the examples below. You can get immediate access to this example workbook by subscribing to the Power Spreadsheets … [Read more...]

In this VBA Tutorial, you learn how to create a clustered or stacked bar chart with macros. This VBA Tutorial is accompanied by Excel workbooks containing the macros I use in the examples below. You can get immediate access to these example workbooks by subscribing to the Power Spreadsheets Newsletter. Use the following Table of Contents to navigate to the section … [Read more...]

In this VBA Tutorial, you learn how to clear cells (including clearing cells totally, their format but not their contents, their contents but not their format, and other similar combinations) with macros. This VBA Tutorial is accompanied by Excel workbooks containing the macros I use in the examples below. You can get immediate access to these example workbooks by … [Read more...]

In this VBA Tutorial, you learn how to create named ranges (for different ranges and with different scopes) with macros. This VBA Tutorial is accompanied by Excel workbooks containing the 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 … [Read more...]

In this VBA Tutorial, you learn how to delete sheets in Excel (in different ways) with macros. This VBA 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 navigate … [Read more...]