krishna334
Active Member
- Joined
- May 22, 2009
- Messages
- 391
This is my code in one of my macros:
If .Cells(r, 9).Interior.ColorIndex = 15 Then
.Cells(r, 3).ClearContents
.Cells(r, 4).ClearContents
.Cells(r, 5).ClearContents
.Cells(r, 6).ClearContents
.Cells(r, 7).ClearContents
.Cells(r, 8).ClearContents
End If
I hope it can be shortened...but how?
If .Cells(r, 9).Interior.ColorIndex = 15 Then
.Cells(r, 3).ClearContents
.Cells(r, 4).ClearContents
.Cells(r, 5).ClearContents
.Cells(r, 6).ClearContents
.Cells(r, 7).ClearContents
.Cells(r, 8).ClearContents
End If
I hope it can be shortened...but how?