Quote Originally Posted by slamet Harto
...For instance: Range I4 has a formula to be copied to range I5:I10.
...
However, some of cells in range I5:I10 has colour / background that no need to paste...
Hi Harto :-)

Just want to make sure I (being rather thick-headed and all) understand.

For each cell in the range, IF it has colorindex 34, then skip. Otherwise copy the formula from I4. Right?

Mark