Is it possible to format sheets (visualize an inventory sheet with white
row - grey row - white row - grey row) via macros?

I currently have the sheets set up so that people can just type in what
they need. However, often people will cut/copy/paste/drag/fill down,
etc and it messes up the formatting I have on the sheet.

Is there a way to set the colors & borders via a macro?


--
wilro85
------------------------------------------------------------------------
wilro85's Profile: http://www.excelforum.com/member.php...o&userid=26935
View this thread: http://www.excelforum.com/showthread...hreadid=572760