See http://www.xldynamic.com/source/xld.CF.html#rows

--

HTH

Bob

"Jock" wrote in message
...
I have used the followinf CF to shade every other row a certain colour:
=MOD(ROW(),2)=0
When data is copied and pasted (xlPasteFormats) in to this sheet, this row
striping is overwritten.
Rather than tweak the copying code, I was wondering if there is a VBA
method
which will achieve the same result as the formula above and stripe
alternate
rows?
--
Traa Dy Liooar

Jock