Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sum difference | Excel Discussion (Misc queries) | |||
subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
what is the difference !!! | Excel Discussion (Misc queries) | |||
difference between the 2 | Excel Worksheet Functions | |||
charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel |