By the way, I am unfamiliar with using the ampersand ('&') for
variable typing. Is this a shortcut for integer?

It's symbolic for 'Long Integer' as row/col indexes are Long type. I
rarely use 'Short Integer' since most of my loops iterate large amounts
of data.

I use the symbols to save typing (I have Lou Gehrig's) and so they were
recommended to me by a veteran VB developer. They are...

VB6 Type Declaration Character Identifiers

% Integer

& Long

! Single-Precision Floating Point

# Double-Precision Floating Point

$ String

@ Currency

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion