Sub HelloWPS() MsgBox "VBA works in WPS!" End Sub To run: .
Sub AutoFitAllColumns() Dim ws As Object Set ws = ActiveSheet ws.Columns.AutoFit End Sub vba wps
If a macro runs slower in WPS, add this at the beginning: Sub HelloWPS() MsgBox "VBA works in WPS
Getting Started with VBA in WPS Office: A Practical Guide vba wps