跪求EXCEL vba大神指点,帮忙把下面这段代码详细注释一下,哪一句是实现什么样的步骤?谢谢。

Set objHS = .Columns("A:A").Find(What:="", LookAt:=xlWhole)
HS_row = .Range(objHS.Address).Row - 1
Set objLS = .Rows("1:1").Find(What:="", LookAt:=xlWhole)
LS_col = .Range(objLS.Address).Column - 1

Set objHS = .Columns("A:A").Find(What:="", LookAt:=xlWhole)
‘在A列查找空单元格,xlWhole-单元格匹配
HS_row = .Range(objHS.Address).Row - 1
’返回上面查找出单元格所在行的上一行
Set objLS = .Rows("1:1").Find(What:="", LookAt:=xlWhole)
‘在第一行中查找空的单元格
LS_col = .Range(objLS.Address).Column - 1
'返回上面查找出的单元格所在列的前一列
温馨提示:内容为网友见解,仅供参考
无其他回答
相似回答
大家正在搜