Blog post link for this tutorial with downloads https://www.businessprogrammer.com/question-time-excel-vba-copy-rows Excel VBA book (affiliate) with reviews https://amzn.to/3axlqih I had a question from a reader of businessprogrammer.com He wanted to use Excel VBA to loop over a list of cells in a spreadsheet range. The macro would then insert a blank row and duplicate the previous row, then make some adjustments to this duplicated excel row. ☕ If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee... https://buymeacoffee.com/seanjohnson ☕ This tutorial covers how to use the range object in Excel vba, writing functions and passing subroutine arguments byreference or byref. In addition, you see how to use the vba range offset and resize methods and the range currentregion command in excel also. Video Production =============== Sony Camera: https://amzn.to/3mqyqfu Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum Microphones --------------- Screen Casting: https://amzn.to/3a2TnHN Microphone and Arm : https://amzn.to/3iwvL2S Talking To Camera: https://amzn.to/3FqXI6b Video Kit ------------- Lights Elgato video Lights: https://amzn.to/3sSK3xg Background Light: https://amzn.to/3uTXyPh Note Taking -------------- Rocketbook reusable notebook https://amzn.to/3sSK3xg DISCLAIMER: This video and description contains affiliate links, this means if you click on one of the product links, I’ll receive a small commission.