Problem: A list of data items have more than 10000, VBA can only access to the number of rows to 1,
The code is as follows:
MsgBox (Sheets (" SAP inventory "). The Range (" a65535 "). The End (xlUp). Row)
Results:


When delete some data items, the result is a normal


Have bosses can explain the

CodePudding user response:

The first step out of the question because I think it should be your data of more than 65536 lines, so you need to understand the End (xlUp) what is the meaning of:

You try in a data area, hold down CTRL + up and down or so key respectively to try and see location to which the cell, and try to understand the positioning principle of

Understand this part I think you will know where the problem is,

The solution to this problem is usually to sheet. Cells (sheet) rows) count, 1). The end (xlup).
in the form of a row

CodePudding user response:

Thank you, explained very well,