Since you said *after* a copy, cut or paste operation, you might try this:

While the range is *still* selected from the paste,
<Format <Auto Format
And pick one of the styles that you see there.

You could also use Conditional Formatting, which will *retain* the
formatting even if you subsequently insert or delete rows.

While the range is *still* selected from the paste,
<Format <Conditional Formatting,
Change "Cell Value Is" to
"Formula Is",
And enter this formula to shade *even* numbered rows:

=MOD(ROW(),2)=0

OR this one for *odd* numbered rows:

=MOD(ROW(),2)=1

Then click on "Format", and choose whatever you like.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"kmwhitt" wrote in message
...
I would like to design a function that will select a range of cells and
assign an alternating color (light gray & no fill) to the rows within that
selection after a copy, cut or paste operation occurs. Anyone have any
ideas?

Thanks,

Kevin