Mostly, I agree with you. If the range is exactly one cell, then I don't see a
difference.

But technically, you can activate a range:

This won't fail in code:
Range("a1:b3").Activate
So you can activate a range.


zhj23 wrote:

Good explanation!!

You mean we can only activate "a" cell and CANNOT activate "a range"? Range
CAN only be "selected" and not "activated"?

zhj23

"Dave Peterson" wrote:

Select A1:B3
then use the tab to activate each cell in the selection.

The activecell is changes with each strike of the tab key. The selection
doesn't change.

Create a test workbook with a handful of worksheets.
Click on the first worksheet and ctrl-click on subsequent sheets.
You've selected a few sheets.

In that set of selected sheets, you can activate any one you want. Not too
dissimilar to the cells in the range.

zhj23 wrote:

Could someone kindly explain or refer me to some sources where I can
distingush between "activation" and "selection" of ranges? and worksheets?

I am quite confuse with the two concepts.

Thanks.

zhj23

--

Dave Peterson


--

Dave Peterson