I have had help on this, but I lack the understanding of address and it
applies here...


For i = 3 To 4
lastcol = .Cells(40, Columns.Count).End(xlToLeft)(1, 2).Column
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
With .Range(.Cells(40, lastcol), .Cells(LastRow, lastcol))
.Formula = "=IF(INDEX(MAPActive!" & Column(i).Address &
iCol & ",MA

In this what is happening with " & Column(i).Address & iCol &" ??


If someone could point me to a good reference to this I would
appreciate it...the help doesn't help much..


Thanks,

Hans