Forum Discussion
GeorgieAnne
Jul 08, 2022Iron Contributor
Named Ranges with _xlfn. prefixes
Hello, I have some VBA code to makes a list of Named Ranges in a workbook. It then visits each of these named ranges and grabs some data from them for further processing. Today, I had this code ...
PeterBartholomew1
Jul 09, 2022Silver Contributor
I think your assessment is along the correct lines, though I too am working by experimentation rather than any authoritative information. 'Single' comes from use of the '@' implicit intersection operator. If you attempt to enter
"= SINGLE(ColumnA)"
Excel will replace it by
"= @ColumnA"
SergeiBaklan
Jul 09, 2022MVP
SINGLE() was introduced at very beginning of DA Excel, bit later Microsoft replaced it with the implicit intersection operator "@"
- PeterBartholomew1Jul 09, 2022Silver ContributorI remember it. What I didn't know was whether the SINGE() form still worked. The automatic conversion was something of a surprise.