我有一个这样的每个循环：
Dim rCell as range
Dim Searchrange as range
Set Searchrange = wss.Range("B12:B36") 'where wss is a defined worksheet
For Each rCell in SearchRange
'do some stuff
'get the row number of the worksheetrow rCell is currently refering to
Next rCell
如何从当前包含的值的原始工作表（wss.）中获取行号rCell？
我可以想象有2种不同的“行号”：
Searchrange例：
Dim SearchRange As Range
Set SearchRange = wss.Range("B12:B36") 'where wss is a defined worksheet
Dim rCell As Range
For Each rCell in SearchRange
'Absolute row number in the worksheet
Debug.Print rCell.Row 'returns 12, 13, 14, … 36
'Row number relative to the SearchRange
Debug.Print rCell.Row - Searchrange.Row + 1 'returns 1, 2, 3, … 25
Next rCell
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句