testing to see the value

"Bob Phillips" wrote:

It is showing 0,1,2,3,4,5 for me one at a time.

Do you really want to show the array index?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Arturo" wrote in message
...
*********************
Dim HeadingsToSync As Variant

HeadingsToSync = Array("1", "2", "3", "ABC", "ABC %Total", "123ABC /
321CBA")

For y = LBound(HeadingsToSync) To UBound(HeadingsToSync)
MsgBox y
Next y
**********************

Why the duce doesn't y display anything other than 0?

Sincerely,
Arturo