Have you ever wanted to automatically number rows of data in Excel? One way to do this is by using the Row function. For example, type a heading such as ID into A1 then in A2 type the formula =Row()-1 In this example suppose you want the numbers to be inserted automatically as you add […]
On a recent Excel VBA Intermediate course everyone thought a macro for converting text to upper or proper case would be helpful. It’s a good one to put into your Personal Macro Workbook then assign to a button on your Quick Access Toolbar. Here’s how to do it: 1. Starting with a blank Workbook record a macro called ConvertCase in the Personal […]