- ©«¤l
- 262
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 280
- ÂI¦W
- 16
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- HK
- µù¥U®É¶¡
- 2015-8-11
- ³Ì«áµn¿ý
- 2024-10-26
|
±µ¤J±zªº¥N½X¸Õ¬Ý, ¦ý¥Ñ©ó¤£ª¾¿z¿ïªº¹ê»Ú°Ï°ì,¤U±¥N½X¬O¥H[a1]¬°·Ç
Sub zz()
If ActiveSheet.FilterMode = True Then
Set rng = [a1].CurrentRegion
zr = rng.Rows.Count
zc = rng.Columns.Count
For i = 2 To zr
If rng.Cells(i, 1).RowHeight > 0 Then Exit For
Next
MsgBox rng.Cells(i, 1).Address(0, 0) & ":" & rng.Cells([a1].End(4).Row, zc).Address(0, 0)
End If
End Sub |
|