Challenge

Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

https://docs.google.com/spreadsheets/d/13RqKBxtBwx1fTil_LFxI93T8lw0iB00O/edit?usp=drive_link&ouid=111044074379090479282&rtpof=true&sd=true

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 Sub

question last

question=>2 check my word file

Your portfolio, next

Ship work like this
in your own course.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.