Submit My Question - Recent Questions - Recent Answer
Msdn China Tech >> visual basic >> VBA

关于EXCEL的一个简单问题

怎样可以知道在EXCEL表单中选中的一行
[20 byte] By [pm666-比笨的猪] at [2008-6-5]
«« CDONTS组件问题,高手帮我!
»» 问问大家
# 1
设置ActiveRange即可。
jianluo56 at 2007-10-22 > top of Msdn China Tech,visual basic,VBA...
# 2
我也想知道
luoluo4529-求学者 at 2007-10-22 > top of Msdn China Tech,visual basic,VBA...
# 3
Application.ActiveCell.Row
xinliangyu-yxl at 2007-10-22 > top of Msdn China Tech,visual basic,VBA...
# 4
我想楼主是这个意思：用户选中了某行，程序怎么知道是选中的哪一行
luoluo4529-求学者 at 2007-10-22 > top of Msdn China Tech,visual basic,VBA...
# 5
ActiveCell.Row
cocolong2002-龙可可 at 2007-10-22 > top of Msdn China Tech,visual basic,VBA...
# 6
Sub abc()
Dim i As Integer
i = ActiveCell.Row
Range("a1").Value = i

End Sub
qkhhwfnh-孤舟 at 2007-10-22 > top of Msdn China Tech,visual basic,VBA...
# 7
Application.ActiveCell.Row
linjimu-沐 at 2007-10-22 > top of Msdn China Tech,visual basic,VBA...
visual basic
VBA

visual basic Hot Topic

visual basic New Topic

visual basic

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified