Data not populating

  • Thread starter Thread starter Carlee
  • Start date Start date
C

Carlee

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
 
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)
 
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
 
Back
Top