Having gotten my matching program to work, I added a part that highlights the changes in the cells. How can I remove the highlights? I know I have seen it before but can't remember how to do it. Thanks.
Having gotten my matching program to work, I added a part that highlights the changes in the cells. How can I remove the highlights? I know I have seen it before but can't remember how to do it. Thanks.
Hi Austen,
You mean something like this maybe?
Option Explicit Sub RemoveColour() Dim c, FirstAddress '//put your own range in here With Worksheets(1).Range("a1:g500") Set c = .Find(what:="*", LookIn:=xlValues) If Not c Is Nothing Then FirstAddress = c.Address Do c.Select c.Interior.ColorIndex = 0 Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address <> FirstAddress End If End With End Sub[/vba] Or, if what you're doing lends itself to a simpler method > [vba]Sub RemoveFill() Range("A1:G500").Interior.ColorIndex = 0 End Sub
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Thanks Johnske