I like my solution best... :-)
-----Original Message-----

Does anyone know how i can create a macro that will allow
me to color
every 'nth' row? I'm thinking a box would pop up asking
which row to
color, ie if i wanted to color every fourth row i'd enter
4, if iwanted
to color every 17th row i'd enter 17 etc... and on
clicking OK the
backgroud color of the respective rows would change color?

Any ideas?


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
guide to creating financial statements
.