Vba Wps !!better!! Instant

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.

| Feature | MS Excel VBA | WPS VBA | |--------|-------------|---------| | Application.ScreenUpdating | Works | Works | | Application.Wait | Works | Works | | UserForm | Full support | Limited (some controls missing) | | ChartObject | Works | May need testing | | FileDialog | Works | Works | vba wps

Sub AutoFitAllColumns() Dim ws As Object Set ws = ActiveSheet ws.Columns.AutoFit End Sub Most people think VBA is exclusive to Microsoft Excel