remove all the  highlighted colour from sheet1

Avinash Singh
Avinash Singh used Ask the Experts™
on
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
Comment
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

Author

Commented:
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