Color every other row
How can i Color every other row in grey, in a dynamic range?
Any help/ideas greatly appreciated |
Color every other row
Try this
http://www.techonthenet.com/excel/qu...nd_format2.php On Aug 2, 8:02 pm, M&M wrote: How can i Color every other row in grey, in a dynamic range? Any help/ideas greatly appreciated |
Color every other row
Sub everyother()
For i = 1 To 100 Step 2 Cells(i, 1).EntireRow.Interior.ColorIndex = 48 Next End Sub adjust the limits to suit the range. -- Gary''s Student - gsnu200735 "M&M" wrote: How can i Color every other row in grey, in a dynamic range? Any help/ideas greatly appreciated |
All times are GMT +1. The time now is 11:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com