you should probably dim y as an integer and then msgbox HeadingsToSync(y)


"Arturo" wrote:

*********************
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 doesnt y display anything other than 0?

Sincerely,
Arturo