Why Listcount - 1

[mahmed1]

Hi

Why do i see listcount - 1

Say i have 6 items in the list, why do we do listcount - 1?

Can someone please break it down how it works

Thanks

 

[Dryver14]

Not sure where you are seeing listcount?

if it is refering to a array in VBA then generaly unless otherwise stated the count starts at 0 which may give seven in the equation.

 

[tweedle]

Generally, when you do this you're accessing the listindex.
The index always starts at 0.
so the first item (count = 1) has an index of 0.
That offset is perpetual through the list.

	C	D	E
4	Count	Index
5	1	0
6	2	1
7	3	2
8	4	3
9	5	4	listcount-1

<colgroup><col style="width: 30px;"><col style="width: 64px;"><col style="width: 64px;"><col style="width: 73px;"></colgroup><tbody>
</tbody>