- Option Explicit
- Sub 提取()
- Dim arr, arr2(1 To 100000, 1 To 2), i As Long, k As Long '声明变量
- i = ActiveSheet.[d1048576].End(xlUp).Row '获取日期的最下面一行的行号
- arr = ActiveSheet.Range("d2:d" & i) '将日期赋值为数组arr
- For k = 1 To UBound(arr)
- arr2(k, 1) = Month(arr(k, 1)) '获取月份
- arr2(k, 2) = Day(arr(k, 1)) '获取日期
- Next
- ActiveSheet.Range("a2").Resize(k, 2).Clear '清空单元格
- ActiveSheet.Range("a2").Resize(k, 2) = arr2 '将获取的值导入单元格区域
- End Sub
复制代码
补充:默认开始行为第二行。 |