Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
1. Check Spelling mistakes in the workbook using VBA Code
Sub HighlightMisspelledells()
Dim c1 As Range
For Each c1 In ActiveSheet.UsedRange
If Not Application.CheckSpelling(word:=c1.Text) Then
c1.Interior.Color = vbRed
End If
Next c1
End Sub
https://docs.google.com/spreadsheets/d/1srb1mysnDegidD43tMYjnLP6nWB7GyWH/edit?usp=sharing&ouid=117786557189013448390&rtpof=true&sd=true
https://docs.google.com/spreadsheets/d/1srb1mysnDegidD43tMYjnLP6nWB7GyWH/edit?usp=sharing&ouid=117786557189013448390&rtpof=true&sd=true