Getting Started with VBA in WPS Office: A Practical Guide
If a macro runs slower in WPS, add this at the beginning: vba wps
Sub AutoFitAllColumns() Dim ws As Object Set ws = ActiveSheet ws.Columns.AutoFit End Sub Getting Started with VBA in WPS Office: A
Application.ScreenUpdating = False Application.Calculation = xlCalculationManual …and reset at the end. vba wps
Have you tried VBA in WPS? What worked or failed? Share below 👇