Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
Other Deliverables=>3
question=>Check Spelling mistakes in the workbook using VBA Code
Sub CheckSpelling()
Dim ws As Worksheet
Dim rng As Range
For Each ws In ThisWorkbook.Worksheets
For Each rng In ws.UsedRange
If Not Application.CheckSpelling(rng.Value) Then
' Highlight the cell with the misspelled word
rng.Interior.Color = RGB(255, 0, 0)
End If
Next rng
Next ws
End Subquestion last
question=>2 check my word file