Hi
for this I would use conditional formating. See:
http://www.cpearson.com/excel/banding.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Tom" schrieb im Newsbeitrag
...
Hey Frank

I want to shade them! I want to shade every other row.

Thanks.
-----Original Message-----
Hi
what are you trying to do with this selection?

--
Regards
Frank Kabel
Frankfurt, Germany

"Tom" schrieb im
Newsbeitrag
...
Hi All

How can i creat a macro that will select every other
colum
in the worksheet?

Thanks in advance.

.