Hit the down arrow to move to the address Start with the cell pointer on the name in column A. The process to fix a single label is pretty tedious. Instead, this particular worksheet had the data going down column A. If you've ever used the Microsoft Word mail merge feature, you know that you need each field in a new column in the worksheet. Someone had given me an Excel worksheet with hundreds of names and addresses.
On the show, I demonstrated the process of recording a macro that will work perfectly if you know how to use the Relative Reference button. Tracy Syrstad and I wrote VBA and Macros Microsoft Excel 2016 in order to help you understand the limitations of recorded code and to teach you how to fix recorded code into something that will work everytime.