Wps | Vba

Sub AutoFitAllColumns() Dim ws As Object Set ws = ActiveSheet ws.Columns.AutoFit End Sub

Most people think VBA is exclusive to Microsoft Excel. But WPS Office (Spreadsheets & Writer) also supports VBA macros. However, there’s a catch — and a simple fix. vba wps

Have you tried VBA in WPS? What worked or failed? Share below 👇 Sub AutoFitAllColumns() Dim ws As Object Set ws

Application.ScreenUpdating = False Application.Calculation = xlCalculationManual …and reset at the end. vba wps

If a macro runs slower in WPS, add this at the beginning:

Sub HelloWPS() MsgBox "VBA works in WPS!" End Sub To run: .