VBA Help

Giganews Newsgroups
Subject: VBA Help
Posted by:  SHalper (scott.m.halp…@gmail.com)
Date: Tue, 25 Jan 2011

I know this is simple so I apologize for posting it.  I'm looking for
the VBA code to take a sheet and sort the rows (below row 2) by a
certain column, descending.  After sorting, I want Excel to provide
shading in alternating rows.  For example:

Row 2 - no shading
Row 3 - Shading
Row 4 - no shading
Row 5 - shading.

Thanks in advance for the help.

Replies