Channel: TeachExcel

Category: Education

Tags: excel vba range referenceselect cells vbaselect ranges vba

Description: Excel VBA Quickie Playlist: youtube.com/playlist?list=PLxhsXZXQXrUDjjYmKn5Wi3V6dkyjGpV9q Excel File: teachexcel.com/excel-tutorial/2474/automatically-updating-range-references-in-vba?src=yt Excel Forum: teachexcel.com/talk/microsoft-office?src=yt How to make a range reference in VBA (Macros) that updates when new data is added to it or data is removed from it. I show you how to do this for regular ranges and also for Tables in the worksheet in Excel. Additional Resources Selecting and Activating Cells (microsoft resource): docs.microsoft.com/en-us/office/vba/excel/concepts/cells-and-ranges/selecting-and-activating-cells How to Select Cells/Ranges (microsoft resource): docs.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/select-cells-rangs-with-visual-basic Excel Courses: - VBA/Macro Course: teachexcel.com/vba-course-update.php - Building Professional Forms: teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_NJapkT68Btc - Email Course: teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_NJapkT68Btc TeachExcel.com #msexcel #excelquickie #tutorial