View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
David Turner David Turner is offline
external usenet poster
 
Posts: 50
Default Alternate row coloring

Myrna Larson wrote

I've written two routines, one to color the rows, the other to remove
the color. I picked a light gray for the shaded rows.


Many thanks, Myrna

Actually 40 returns a peach color here. I chose 15 for light grey. And I
like the reset sub to get things back to square one.

One slight modification. Rows 1-5 contain stuff I would like to exclude
from the coloring and start with row 6.

--
David