Excel VBA Variable Declaration Ambersand

Question

In a great VBA code example @https://medium.com/@daniel.ferry/excel-vba-get-unique-values-easily-592162f52c6e there is followng Variable declaration:

Function DistinctVals(arr, Optional col = 1)
    Dim i&, v: v = arr

Everthing works fine in Windows but on Mac there is a ByRef argument type mismatch. My question is not about the mismatch - there is even Dictionary not working on Mac, but it's about the never seen before and can't find with search engine "Dim i&" Declaration. In other languages the ambersand stands for Reference, but a) this does not make sense in this context and b) it's not documented - at least I can't find any.

Thanks in advance

It means Dim i As Long.

VBasic2008
– VBasic2008

2022-07-02 19:21:05 +00:00
Commented Jul 2, 2022 at 19:21 — VBasic2008
– VBasic2008, Commented Jul 2, 2022 at 19:21
For a MAC dictionary alternative, you might try using this

Spectral Instance
– Spectral Instance

2022-07-02 21:35:41 +00:00
Commented Jul 2, 2022 at 21:35 — Spectral Instance
– Spectral Instance, Commented Jul 2, 2022 at 21:35

ENIAC · Accepted Answer · 2022-07-02 19:39:01Z

1

This means Long type. From VBA reference:

The shorthand for the types is: % -integer; & -long; @ -currency; # -double; ! -single; $ -string

answered Jul 2, 2022 at 19:39

ENIAC

1,1983 gold badges11 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3665647 Over a year ago

Thank you very much for quick response! [ I had already been at this site but had overseen this part ]

ENIAC Over a year ago

@user3665647, yeah. Some information from documentation is not so easy to find :)

Collectives™ on Stack Overflow

Excel VBA Variable Declaration Ambersand

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related