随笔分类 - VBA
摘要:To resolve this problem, follow these steps:Because cell comments are hidden by default, select the cell containing the comment, right-click the cell, and then click Show Comment on the shortcut menu.If the workbook is not shared, move the pointer to the edge of the comment until the pointer turns i
阅读全文
摘要: '将 A 转成 1Function ConvertExcelNumToInt(colName As String) As Integer Dim i As Integer Dim rtn As Integer If Len(colName) = 0 Then ConvertExcelNumToInt = 0 Exit Function End If colN
阅读全文