按编号获取列范围 [英] Get Column Range by number
问题描述
EXCEL 2007 VBA
EXCEL 2007 VBA
我正在使用它来查找列中vShape中的字符串:
I'm using this to find the string in vShape in a column:
设置rngTrip = wksTrips .Range(&H:H")。查找(vShape ,,, xlWhole)
Set rngTrip = wksTrips.Range("H:H").Find(vShape, , , xlWhole)
我现在只知道列号,例如8
I now only know the column number e.g. 8
如何使用find才知道列号?
How do I use find only knowing the column number?
设置rngTrip = wksTrips.Range(8).Find(vShape ,,, xlWhole)当然不起作用。
Set rngTrip = wksTrips.Range(8).Find(vShape, , , xlWhole) doesn't work of course.
推荐答案
设置rngTrip = wksTrips.Range(" H:H")。查找( vShape ,,, xlWhole)
Set rngTrip = wksTrips.Range("H:H").Find(vShape, , , xlWhole)
上面你已经在第8列了.H列是第8位。
In above you are already usning column 8.H column is eighth.
FIND可以在整个工作表范围内工作,但限制搜索范围总是更好。
FIND can work on whole range of sheet but it is always better to limit the search range.
这篇关于按编号获取列范围的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!