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/1fHTPlVJYl2Qht69SPgfrj8CUneKFhLEW/edit?usp=drive_link&ouid=108321187990630390366&rtpof=true&sd=true
Public Sub convert_to_pdf()
Range("A1:D7").ExportAsFixedFormat xlTypePDF
End Sub
Public Sub Check_spelling_mistake()
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