Excelgoodies
+44 (0)20 3769 3689
Excelgoodies logo +44 (0)20 3769 3689
+44 (0)20 3769 3689  

 Business Professionals

 Techno-Business Professionals

 Technology Professionals

Home

|

About Us

|

Contact Us

Programs & Courses

New

Home | About Us | Contact Us

+44 (0)20 3769 3689

support@excelgoodies.uk

ExcelGoodies WorldwideUK | USA | Australia | Singapore | Phillipinnes

How to highlight cells with mis-spelled words using VBA?

 

The below code will check each cell from the selection and highlight the cell where is a misspelled word.

 

Sub HighlightMisspelledCells()

Dim rng As Range

For Each rng In ActiveSheet.UsedRange

If Not Application.CheckSpelling(word:=rng.Text) Then

rng.Style= "Bad" End If

Next rng

End Sub

 

Explore extensive Excel VBA Programming Course here and, learn to automate your routine Excel Reports, Tasks and Processes.

 

Happy Excelling
Team Excelgoodies

VBA & Python

New

Next Batches Now Live

Power BIPower BI
Power BISQL
Power BIPower Apps
Power BIPower Automate
Power BIMicrosoft Fabrics
Power BIAzure Data Engineering
Explore Dates & Reserve Your Spot → Reserve Your Spot →

Related Articles