TechTalk – Excel VBA : Datatype Long

Learnt something new today.
The two sets of VBA code mean the same thing.
The ampersand (&) type-declaration character represents a Long.
Cool ain’t it?

Dim x as Long
x = ActiveSheet.UsedRange.Rows.Count

Or

Dim x&
x = ActiveSheet.UsedRange.Rows.Count

n1849778
About the
I am a software developer in Calgary, Alberta, Canada with passion in getting my fingers in any new technology. I started software development when I was 10 years old and have never looked back. Now with well over 35 years of software development, I wanted to share some of these key knowledge with the people of the world in the wide web.