SpecialCells:
find special cells 指定类型查找
1. To find the end of a range
- find the last row
- 适用于range中间没有空行,End(xlDown)相当于ctrl + down,直接拉到Range最底下
- Row => get the number of row
-
another way to find the last row
从整个表的最后一行jump back
Rows.Count => find how many rows in the worksheet -
find next empty cell
-
find the last column