Hi..

Just out of interest.. do you have 34 more lines similar to this:

MyData(1) = "='" & JustPathNew & FileName & "'!CellName"
I mean.. are you populating the MyData array via 35 lines of code or using a loop etc?