vba判断excel最后一行最后一列

来源：哗拓教育

vba判断excel最后⼀⾏最后⼀列

Function LastColumn() As Long

2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. Dim ix As Long

ix = ActiveSheet.UsedRange.Column - 1 + ActiveSheet.UsedRange.Columns.Count LastColumn = ix End Function

Function LastRow() As Long Dim ix As Long

ix = ActiveSheet.UsedRange.Row - 1 + ActiveSheet.UsedRange.Rows.Count LastRow = ix End Function

因篇幅问题不能全部显示，请点此查看更多更全内容

查看全文

违法及侵权请联系：TEL:199 1889 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务