只需一步,快速開始
1970-1-1 08:00| 發(fā)布者: 未知| 查看: 6576| 評(píng)論: 0
對(duì)啊,用內(nèi)部函數(shù)來獲得,最快了。比如用下邊的代碼。ActiveCell.FormulaR1C1 = "=MAX(R[-26]C[-1]:R[-2]C[-1])"是獲得A1到A25之間的最大值。找到之后用Cells對(duì)象的Find或FindNext方法來找所在單元格就可以了。比如用如下代碼 Cells.Find(What:="1313123", After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False).Activate Debug.Print ActiveCell.Row Debug.Print ActiveCell.Column
評(píng)論
|站長郵箱|小黑屋|手機(jī)版|Office中國/Access中國 ( 粵ICP備10043721號(hào)-1 )
GMT+8, 2025-7-13 08:21 , Processed in 0.081856 second(s), 16 queries .
Powered by Discuz! X3.3
© 2001-2017 Comsenz Inc.