On 2002-04-21 13:44, Tom Urtis wrote:
Based on your question, it appears you want no cell on the sheet to have color, regardless of whatever range you may be working in.
In general, removing all the interior color from all the cells of the sheet would look something like this:
Sub NoColor()
Cells.Interior.ColorIndex = xlNone
End Sub
Maybe there's more to the question though, so if you mentioned the variable range because other cells outside of that range have interior color that must be left alone, please repost.