remove all the  highlighted colour from sheet1

Avinash Singh
Avinash Singh used Ask the Experts™
i want to remove all the  highlighted colour from sheet1
there will be data with highlighted colour  or it will be only highlighted colour , whatever it is if highlighted colour is found in a sheet then remove that highlighted colour
my sheet is highlighted with yellow colour
in vba language the colour is
.Color = 65535

i want to do all this by vba
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Use this to remove all highlighted colours on Sheet1.

Sub RemoveHighlightColours()
    Worksheets("Sheet1").Cells.Interior.ColorIndex = xlNone
    Worksheets("Sheet1").Cells.Font.ColorIndex = xlAutomatic
End Sub

Open in new window


Thnx Ejgil sir for giving ur precious time and support to this post

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial