How do I change the following coding so that it will highlight the the entire row where the selected cell is located?
[vba]
Selection.Insert Shift:=xlToRight
Rows("42:42").Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
[/vba]
I know that Rows("42:42").Select is the problem; I am just not sure what needs to be there so that it highlights the whole row and not just the cell that is selected (if that is possible)...
Thanks,