![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
office操作技巧
hyspeter
这个作者很懒,什么都没留下…
展开
-
word中判断选择内容是否在表格中
Selection.Information(Word.WdInformation.wdWithInTable) 参阅 WdInformation 可以是下列 WdInformation 常量之一: wdActiveEndAdjustedPageNumber原创 2008-04-08 10:48:00 · 4611 阅读 · 1 评论 -
excel 获取最后一个非空单元格
Private fMaxRow As IntegerPrivate fMaxCol As IntegerPrivate ExcelHWD As Excel.ApplicationfMaxRow = ExcelHWD.Selection.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Rows.RowfMaxCol = ExcelHWD.Sel原创 2008-04-08 13:55:00 · 4036 阅读 · 1 评论 -
excel 获取当前单元格
Excel的自动化类Private ExcelHWD As Excel.Application行标记Private fMrkRow As Integer = -1列标记Private fMrkCol As Integer = -1fMrkRow = ExcelHWD.Selection.Rows.RowfMrkCol = ExcelHWD.Selection.Columns.Column原创 2008-04-08 13:19:00 · 3529 阅读 · 0 评论