当前位置: 代码迷 >> 综合 >> VBA查询单元格是否数值型
  详细解决方案

VBA查询单元格是否数值型

热度:19   发布时间:2024-02-11 22:21:12.0

Function isNum(rng) As Boolean
Dim i As Integer
On Error Resume Next
i = rng
isNum = Not Err.Number = 13
End Function

Sub sdk()
For Each rng In Range("U2:Z527")
If isNum(rng) = False Then rng.Select
Next
End Sub

  相关解决方案