You are a hero! Works perfectly. Let this code replace the 400 other,
more complicated examples of code I found that attempt to do the same
thing.
On Jul 1, 2:34 am, Stuart Redmann wrote:
> On 30 Jun. Kurt wrote:
>
> > > > 1. The comment in this code has as an example, "ShadeAlternateRows
> > > >
On 30 Jun. Kurt wrote:
> > > 1. The comment in this code has as an example, "ShadeAlternateRows
> > > Range("A1:D50"), 27, 2", but where in the actual code do you put this
> > > information?
Stuart Redmann wrote:
> > That depends on when the highlighting should happen.
Kurt wrote:
> I'm most inte
> > 1. The comment in this code has as an example, "ShadeAlternateRows
> > Range("A1:D50"), 27, 2", but where in the actual code do you put this
> > information?
>
> That depends on when the highlighting should happen.
I'm most interested in learning how to do it manually (e.g., after
manually sel
On 29 Jun., Kurt wrote:
> I would like to highlight every other row in a range (A5:L40).
> I've seen lots of macro samples to shade alternate rows, but can't get
> any to work.
>
> For example, I found this one:
>
> Sub ShadeAlternateRows(rngTarget As Range, intColor As Integer,
> lngStep As Long)