andrewb90
Well-known Member
- Joined
- Dec 16, 2009
- Messages
- 1,077
Hello All,
I have this code that I am using, however, I need to change part of it, and I don't seem to be doing it correctly.
I need to change it so that if A25 in the sheet "Scheduler" has the cell filled in then cell B10 in the sheet "Print" will say "OFF"
This would apply to A25:T88 (and would fill down and right, accordingly on the "Print" sheet)
Now, there are going to be a few rows where there wouldn't be any need to copy, I don't suppose that matters as long as all the cells that are colored get the text.
Thanks,
Andrew
I have this code that I am using, however, I need to change part of it, and I don't seem to be doing it correctly.
Code:
Sub OFF()
Dim i As Integer
With Sheets("Print")
For i = 5 To 25
If .Cells(i, 1).Interior.Color = RGB(255, 209, 117) Then .Cells(i + 5, 6).Value = "OFF"
Next i
End With
End Sub
This would apply to A25:T88 (and would fill down and right, accordingly on the "Print" sheet)
Now, there are going to be a few rows where there wouldn't be any need to copy, I don't suppose that matters as long as all the cells that are colored get the text.
Thanks,
Andrew