Thanks but these are all CF solutions and as such, can be deleted/removed. I
require something which cannot change regardless of whether the user applies
a filter, sorts a selection or copies formatting from a different sheet.
Any suggestions welcomed.
--
Traa Dy Liooar

Jock


"JLGWhiz" wrote:

See "Shading Alternate Rows in an Excel Worksheet" in the Excel help menu.



"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


.