Fix excel treat "" as nonblank for a range by using vba code

Fix excel treat "" as nonblank for a range by using vba code

    ws.Range("M18:GJ517").Value = ws.Range("M18:GJ517").Value