Averageæ¯EXCLEçå½æ°ï¼å¨VBAä¸ä¸è½ç´æ¥ä½¿ç¨ã
ä» Visual Basic ä¸è°ç¨å·¥ä½è¡¨å½æ°
å¨ Visual Basic ä¸ï¼éè¿ WorksheetFunction 对象å¯ä½¿ç¨ Microsoft Excel å·¥ä½è¡¨å½æ°ã
ä»¥ä¸ Sub è¿ç¨ä½¿ç¨ Min å·¥ä½è¡¨å½æ°æ¥å³å®å¨æ个åå
æ ¼åºåä¸çæå°å¼ãé¦å
ï¼å°åé myRange 声æ为 Range 对象ï¼ç¶åå°å
¶è®¾ç½®ä¸º Sheet1 ä¸ç A1:C10 åå
æ ¼åºåãæå®å¦ä¸ä¸ªåé answer 为对 myRange åºç¨ Min å½æ°çç»æãæåï¼answer çå¼å°±è¢«æ¾ç¤ºå¨æ¶æ¯æ¡ä¸ã
Sub UseFunction()
Dim myRange As Range
Set myRange = Worksheets("Sheet1").Range("A1:C10")
answer = Application.WorksheetFunction.Min(myRange)
MsgBox answer
End Sub
å¦ææ¨ä½¿ç¨çå·¥ä½è¡¨å½æ°éè¦ä¸ä¸ªåå
æ ¼åºåå¼ç¨ä½ä¸ºåæ°ï¼åå¿
é¡»æå®ä¸ä¸ª Range 对象ãä¾å¦ï¼æ¨å¯ä»¥ç¨ Match å·¥ä½è¡¨å½æ°æç´¢åå
æ ¼åºåãå¯ä»¥å¨å·¥ä½è¡¨åå
æ ¼ä¸è¾å
¥å
¬å¼ï¼å¦â=MATCH(9,A1:A10,0)âãä½æ¯ï¼æ¨åºå¨ Visual Basic è¿ç¨ä¸æå®ä¸ä¸ª Range 对象æ¥è·åç¸åçç»æã
Sub FindFirst()
myVar = Application.WorksheetFunction _
.Match(9, Worksheets(1).Range("A1:A10"), 0)
MsgBox myVar
End Sub
温馨提示:答案为网友推荐,仅供参考