something not quite right. I'm using this on 12 sheets (jan to dec) in cell A1 on each sheet. When i copy and paste your formula into each sheet, although it shows that sheet's name in A1 it also shows the same thing in the other 11 sheets? e.g. i paste it into A1 on the june sheet and all the sheets jan to dec now also show june in their A1 cell.