The document in the old computer to Office 2003 can be used normally, but computer use is an error in the Office, (tried the following version: 2019/WPS Office 2016/2013) show just a little big trouble in using familiar with VBA, thank bosses first!

CodePudding user response:

[D3] into the range (" D3 "). The text
Try
Other parts of the same

CodePudding user response:

reference 1/f, crispy big ice cream reply:

[D3] into the range (" D3 "). The text
Try
Elsewhere in the same way

Before I press F8 after changed, the cursor now appeared in the new location, such as above:

CodePudding user response:

Lets you change to the range (). The text because your screenshot, is the cell text comparison,
. The End () operation is in view of the range, don't. The text
Is the range (" A65535 "). The End (xlUp). Row...

CodePudding user response:

reference 3 floor crispy large ice cream response:

lets you change to the range (). The text because your screenshot, is the cell text comparison,
. The End () operation is in view of the range, don't. The text
Is the range (" A65535 "). The End (xlUp). Row...

After modification, the "u=Range (" A65536"). The End (xlUp). Row + Range (" D65536 "). The End (xlUp). The Row - 4 "or error

CodePudding user response:

This kind of writing, in MS Office is no problem, but can't write in the WPS Office,
A lot of things have differences in details, remember that even the Left function, are written in VBA. Left to just go...


I am here not installed WPS to actual test, can say about your method,
You try to put these Range (), all written ActiveSheet. The Range ()
Or Application. The Range ()
Why don't you see.