Excel File: https://www.teachexcel.com/excel-tutorial/2195/excel-vba-tip-for-making-relative-cell-references?nav=yt
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt
Make your life easier! Stop selecting cells in macros! Here, you’ll learn how to do whatever you want with a worksheet cell without selecting the cell or the worksheet. This includes editing cells, getting values from cells, and much more.
This tutorial will help you streamline your macro creation process and it will also teach you the skills you need to edit a recorded macro to make it work better.
I’ll first show you the bad, but working, way to select cells in a workbook in Excel, and then I’ll show you the correct way to do it.
After this tutorial, you’ll be on your way to creating much more useful and simpler macros in Microsoft Excel.
If you have any questions, make sure to let me know! 🙂