Excel VBA Activate vs Select vs Selection vs ActiveCell

Опубликовано: 05 Ноябрь 2024
на канале: TeachExcel

19,195

300

Excel Macro tutorial that explains the difference between Activate and Select as well as Selection and ActiveCell - these are often-confused yet important things to understand in VBA and Macros.

Excel File: https://www.teachexcel.com/excel-tuto...
Excel Forum: https://www.teachexcel.com/talk/micro...

This tutorial will cover many examples of when and how to highlight cells in Excel using Select and Activate and then explain when to use each one. As well, this tutorial will cover the differences between Selection and ActiveCell and then tell you when and how to use each one.

The concepts in this tutorial are often mixed-up or confused with one another and this tutorial serves the purpose of untangling the mess and trying to explain everything to you in a simple and easy-to-understand way.

As well as containing many examples, the macros included in this tutorial are heavily commented so that you can use them as a reference if you get stuck in the future.

This tutorial is part of a larger online course that I will be making for TeachExcel, so stay tuned for updates.)

I hope you enjoy this tutorial! Stay safe out there!

TeachExcel.com

#excel #tutorial #onlinecourse