|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.