我写了一段代码
Dim objRange As range
Dim objcell As range
Dim x As Integer
Dim y As Integer
Sheets(1).Select
Set objRange = Sheets(1).range("a1", "a10")
Set objcell = objRange.Find(what:="ee")
x = objcell.Row
y = objcell.Columnsheet中的数据是
A1 ee
A2
A3 ee
A4 ee为什么find后返回结果中的row等于3,到了A3单元格,没有查找A1单元格
Dim objRange As range
Dim objcell As range
Dim x As Integer
Dim y As Integer
Sheets(1).Select
Set objRange = Sheets(1).range("a1", "a10")
Set objcell = objRange.Find(what:="ee")
x = objcell.Row
y = objcell.Columnsheet中的数据是
A1 ee
A2
A3 ee
A4 ee为什么find后返回结果中的row等于3,到了A3单元格,没有查找A1单元格
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货