Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Whats the difference between activating a range and selecting a range?

April 26, 2017activating difference range selecting

0

Posted

Whats the difference between activating a range and selecting a range?

1 Answer

0

Posted

In some case, the Activate method and the Select method have exactly the same effect. But in other cases, they produce quite different results. Assume that range A1:C3 is selected. The statement below activates cell C3. The original range remains selected, but C3 becomes the active cell.