I tried two different ways of changing cell values and attributes as follows:

1) For Rw = 4 To 12
For Cm = 2 To 10
Cells(Rw, Cm).Value = 0
Cells(Rw, Cm).Font.Size = 24
Cells(Rw, Cm).Font.ColorIndex = 1
Next Cm
Next Rw

2) For Each c In Worksheets("Sheet1").Range("B4:J12")
c.Value = 0
c.Font.Size = 24
c.Font.ColorIndex = 1
Next c

Both are straight out of Excel VB help. Execution of both terminate
immediately after the value of the first cell is changed, with no error
message. If I comment out the .value statements, they both run fine. Cells
formatted as Number.

Has anybody run into this before ? What am I missing ?

Hi
Works for me. Are you in break mode in the editor maybe or something
like that? Try Run, Reset and Debug, Clear Breakpoints.
regards
Paul

Andy wrote:
I tried two different ways of changing cell values and attributes as follows:

1) For Rw = 4 To 12
For Cm = 2 To 10
Cells(Rw, Cm).Value = 0
Cells(Rw, Cm).Font.Size = 24
Cells(Rw, Cm).Font.ColorIndex = 1
Next Cm
Next Rw

2) For Each c In Worksheets("Sheet1").Range("B4:J12")
c.Value = 0
c.Font.Size = 24
c.Font.ColorIndex = 1
Next c

Both are straight out of Excel VB help. Execution of both terminate
immediately after the value of the first cell is changed, with no error
message. If I comment out the .value statements, they both run fine. Cells
formatted as Number.

Has anybody run into this before ? What am I missing ?