Home > Software engineering >  Why macros generated article wages the same failure in the WPS?
Why macros generated article wages the same failure in the WPS?

Time:03-03

Why (Sub)
'
'why Macro
'macro recording by 20130510, time: 2019/05/01
'

'
ActiveCell. Offset (0, 0). The Range (" A1 "). Select
Selection. Copy
ActiveCell. Offset (2, 0). The Range (" A1 "). Select
ActiveCell. Offset (0, 0). The Range (" A1 "). Copy
ActiveSheet. Select the Replace:=False
Selection. Insert Shift:=xlShiftDown
ActiveSheet. Select the Replace:=False
ActiveSheet. Select the Replace:=False
ActiveCell. Offset (0, 0). The Range (" A1 "). Copy
ActiveCell. Offset (2, 0). The Range (" A1 "). Select
End Sub
'(above the generated code for WPS form in the same operation, operation failure,)


Sub copy interlaced (same)
Dim As Long I
For I=2 To 17
'copy interlaced same macro
'

'
ActiveCell. Rows (" 1 "). EntireRow. Select
Selection. Copy
ActiveCell. Offset (2, 0). The Rows (" 1 "). EntireRow. Select
Selection. Insert Shift:=xlDown
ActiveCell. Select
Next
End Sub
'(above to Excel in the same operation generated code, everything is normal,)
And under the guidance of the great god why is this?
'the WPS is disabled????????????????????????????????????????????????????

CodePudding user response:

Not a "VBA compatibility" of the original WPS, said it also may be "disabled",
In Excel code that can be executed correctly, to the WPS "runs abnormally" is a normal phenomenon,


Though you are "the same operation" recorded under the macro code, but you can see "code logic is not the same,"

CodePudding user response:

If the WPS and office use, free, also the office sell so expensive and justified?
  •  Tags:  
  • VBA
  • Related