I
Ian Chappel
I haven't been doiung any programming for a while, so maybe I'm a bit rusty,
but why do these two snippets produce two different results?
----DOES WHAT I EXPECT----
r = ActiveCell.Row
Rows(r + 1).EntireRow.Insert
Rows(r + 1).Font.ColorIndex = 3
----COLOR'S ROW 1 FURTHER DOWN----
r = ActiveCell.Row
With Rows(r + 1)
.EntireRow.Insert
.Font.ColorIndex = 3
End With
I dare say the answer's staring me in the face, but I can't see it!
but why do these two snippets produce two different results?
----DOES WHAT I EXPECT----
r = ActiveCell.Row
Rows(r + 1).EntireRow.Insert
Rows(r + 1).Font.ColorIndex = 3
----COLOR'S ROW 1 FURTHER DOWN----
r = ActiveCell.Row
With Rows(r + 1)
.EntireRow.Insert
.Font.ColorIndex = 3
End With
I dare say the answer's staring me in the face, but I can't see it!