It works fine for me.

Do you get an error message of any kind?

Is the sheet with January on B4 active? Is it protected?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Carlee" wrote in message
...
Hi there,
I am using the following code to populate my MTD and YTD columns. They
were
working fine, but now are not. Not sure what i am missing. Any ideas?
Nothing seems to work, even when i break it right down.

Code:
If Range("B4") = "January" Then
'MTD
Range("AH7").Value = "worked"
'Range("AH7").Value = Worksheets("Year at a
Glance").Range("C5").Value 'operating hours

Range("AH9:AH10").Value = Worksheets("Year at a
Glance").Range("C7:C8").Value 'Plant & Total Availability
Range("AH11").Value = Worksheets("Year at a
Glance").Range("C9").Value 'Water Feed Flow, m3
Range("AH12").Value = Worksheets("Year at a
Glance").Range("C10").Value 'water feed flow, m3/h

....
End if
--
Carlee