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.

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" wrote in message
. au...
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.

Sensational explanation. Thank you.

Bob Phillips wrote:
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.