Plain descriptions required

[SmilingPolitely]

Using small monosyllabic words, can someone please explain the
difference in VBA "sheets" vs "worksheets" and "activate" vs "select"
and consequences in improper use.

Any help is appreciated.

 

[Bob Phillips]

Sheets refers to the many types of sheets available in a workbook, which
includes worksheets, charts, dialog sheets etc. whereas worksheets only
refer to worksheets, those cellular, grid-like sheets for formulae,
analysis, etc.

Select selects an object, such as a shape, a range, a button, etc. The
selection can be multiple items, such as a range of cells, or a collection
of shapes. Activate is on a single cell, or a single shape, and would be
within the selection. When a cell is activated, it can be all, or part of, a
range of cells.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[SmilingPolitely]

Sensational explanation. Thank you.