如何在Excel工作表中查找当前选定单元格的范围 [英] How to find the range of currently selected cells in an excel worksheet
问题描述
大家好!这一定很容易,但是我已经挣扎了一段时间(是的,我用谷歌搜索,但无法理解我发现的东西).
我的过程收到一个excel工作簿作为输入参数.我需要找到当前选择的单元格范围...
到目前为止,我唯一的代码行
Hello everyone! This must be quite easy, but I have been struggling for a while now (and yes, I googled but could not make sense of what I found).
My procedure receives an excel workbook as input parameter. I need to find the currently selected cell range...
My only line of code so far
xlWorksheet = xlInputWorkBook.ActiveSheet
有谁知道如何检索选定的单元格范围的线索吗?
我的猜测是xlWorksheet.Cells.SomePropertyICanNotFind
TIA为您提供帮助!
PS:我没有使用VBA,而是使用VB.NET来构建一个独立的应用程序
Does anyone have a clue as how to i retrieve the selected cell range?
My guess is xlWorksheet.Cells.SomePropertyICanNotFind
TIA for your help!
PS: I am not using VBA, but VB.NET to build a standalone application
推荐答案
您正在寻找的实际上只是您所期望的...并且那是Selection
http://msdn.microsoft.com/en-us/library/aa196885%28v = office.11%29.aspx [ ^ ]
在vb.net中,它是Application的属性.这是因为Excel是单用户,因此一次只能选择一个.
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.application_properties.aspx [ ^ ]
祝你好运!
What you are looking for is actually just what you would expect... and that isSelection
http://msdn.microsoft.com/en-us/library/aa196885%28v=office.11%29.aspx[^]
In vb.net it is a property of Application. This is because Excel is single user and therefor can have only one selection at a time.
http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.application_properties.aspx[^]
Good luck!
这篇关于如何在Excel工作表中查找当前选定单元格的范围的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!