ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Hi,
Below is a section of my code.
Can you advise please how i can write the code in red correctly,basically i need to be B8 then down the page.
Reason being when i reach row 3000 i wont remember why its stopped working.
Thanks
Below is a section of my code.
Can you advise please how i can write the code in red correctly,basically i need to be B8 then down the page.
Reason being when i reach row 3000 i wont remember why its stopped working.
Thanks
Rich (BB code):
Range(Cells(Target.Row, myStartCol), Cells(Target.Row, myEndCol)).Interior.ColorIndex = 8
Target.Interior.Color = vbGreen
Range("B8:B3000").Font.Size = 12
Application.ScreenUpdating = True
End Sub