VBA Array element changes by itself!

[ExcelMarc]

Using Excel 2007. Just started learning VB a few months ago and stuck on this one: I have 1 workbook with 3 worksheets. 2 worksheets have large tables of data (>60 cols x >5000 rows). I am writing a VBA array (9 elements in total) to write formulas into cells on one worksheet, and part of the formula is making reference to cells on the other worksheet. For ex in worsheet called OLD_MIF I have:
Dim List as Variant
List = Array(...."IF(ISERROR(MATCH(F2,NEW_MIF!F:F,0)),0,1)", "IF(ISERROR(MATCH(G2,NEW_MIF!G:G,0)),0,2)"....)
However when VB writes these formulas into the cells (in sheet OLD_MIF) Excel changes the "NEW_MIF!F:F" reference to "NEW_MIF!S:S" and the "NEW_MIF!G:G" to "NEW_MIF!T:T".
I tried many things but keep getting the exact same result!
Any help would be greatly appreciated. Thanks )

 

[GlennUK]

Showing us the actual macro code that writes to the cells would be a start.

 

[ExcelMarc]

Glenn, thank you for your post. I found a workaround about 5 minutes ago but I might still post more details when I have a chance as I would love to understand why I was having this problem. I'm new in this forum (or any other forum for that matter - as if my "post count of 1" didn't already give that away) so I have to read more about how to post codes and attach files, etc.
Basically my problem seems to be caused by my VB code inserting columns at the start of my data table (in both sheets) plus I had some code to search for 5 specific column headers in each table, cut the entire column and paste them at the start of my table as well.
I rewrote my code so that I have no more "inserting" and now my formulas are correct