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

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" <(E-Mail Removed)> wrote in message
news:EC82347D-6A4E-48C0-A853-(E-Mail Removed)...
> 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

Does it do *anything* ?
How is the code being run ?

I would suggest starting by qualifiying all of your ranges with a worksheet
object. Omitting this can cause problems when the activesheet is not the
one expected.

Also, you might think about using the worksheets' code names instead of
their tab names: it's easier to write the code and if a user changes the
tabname it won't break your macro. The sheet codenames can be viewed (and
changed) in the VBE. To change the name, select a sheet in the VBE and edit
the Name in the Properties pane (F4).

Tim


"Carlee" <(E-Mail Removed)> wrote in message
news:EC82347D-6A4E-48C0-A853-(E-Mail Removed)...
> 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