i have eomonth formulas in b5:b16. they are formatted in month name MMMM
this code runs until it gets to october, the 10th month, and throws a 1004
error, so oct, nov and dec do not update. anyone know what the difference would
be?
c1 contains the name of the workbook
example formula the code creates: =Kelly.xls!Feb_Short
i = 5
For i = 5 To 16
Cells(i, 3).Formula = "=" & Range("c1") & ".xls!" & Format(Left(Cells(i, 2), 3),
_
"MMM") & "_Short"
Cells(i, 4).Formula = "=" & Range("c1") & ".xls!" & Format(Left(Cells(i, 2), 3),
_
"MMM") & "_Over"
Next
--
Gary
Bookmarks