CONTEXT
As far as I can tell, a major reason merged cells are avoided is that some VBA and excel functions
use headings, expecting the headings to be ONLY one cell wide. Apparently Headings more than one
cell wide can introduce unpredictable results.

Problem:
Unlike merged cells, for which vba has methods and properties that operate on a merged selection,
"Center Across Selection" does not appear to have such assistance. Is that observation correct?

I would like to identify the range which covers the selected region when i use "Center Across Selection".
I then need to identify the string that is within that selected region.

it is not apparent to me that excel stores the selection used in Center Across Selection and makes
the selection available to me to identify its address or other properties (like a text string within)

any thoughts?