![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
笔记
小四轮_
天下熙熙,皆为利来,天下嚷嚷,皆为利往!
展开
-
vba清空剪贴板方法
方法一Private Declare Function OpenClipboard Lib “user32” (ByVal hWnd As Long) As LongPrivate Declare Function CloseClipboard Lib “user32” () As LongPrivate Declare Function EmptyClipboard Lib “user32” () As LongPublic Sub JustEmptyClipboard()OpenClipboa原创 2021-03-04 09:29:09 · 7654 阅读 · 1 评论 -
[转载]VBA获取最后一个单元格行号的几种方法
[方法一]ActiveSheet.Range(“A” & Rows.Count).End (xlUp).Row[方法二]ActiveSheet.Range(“a1048576”).End(xlUp).RowActiveSheet.Range(“a65536”).End(xlUp).Row[方法三] ActiveSheet.Cells(Rows.Count,1).End(3).Row[方法四] ActiveSheet.range(“A1”).CurrentRegion.Rows.Count原创 2020-10-19 11:59:17 · 6863 阅读 · 0 评论