Delete interior color

[verluc]

Can anybody help me with the following :

I have to delete the interior color of sheet1 with a macro.
I don't know how many rows this sheet has.
(it is variable).
Many thanks for help.

 

[Tom Urtis]

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.

 

[verluc]

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.

Many thanks Tom, that's what I am looking for.