§Ú·Q§ä¤@Ó½d³ò¤º³Ì¤jÈ,¨Ã§ä¨ì©Ò¹ïÀ³¾î¦C/Áa¦CªºÈ
¦p½d¨Ò¤¤³Ì¤jȬ°18.66423, ¹ïÀ³¿Å¦CȬ°400, Áa¦CȬ°25, §Úªºµ{¦¡¦p¤U
Col = Range("B15").End(xlToRight).Column
Rw = Range("B15").End(xlDown).Row
Range("H11") = Application.Max(Range(Cells(16, 2), Cells(Rw, Col)))
For j = 16 To Rw
For k = 2 To Col
MAXV = Range("H11").Value
If Cells(j, k) = MAXV Then
Range("I11") = Cells(j, 1).Value
Range("J11") = Cells(15, k).Value
GoTo 5
End If
Next k
Next j
Msgbox (MAXV, Range("I11"), Range("J11"))
§Ú§Q¥Îloop¥h§ä¹ïÀ³³Ì¤jȪº¾î/Áa¦CÈ, ¦ý¬O·í³oÓ½d³ò«D±`¤j®É,¥i¯à¬O1500*1500ªº°}¦C, °õ¦æ®É¶¡«h·|Åܪø, ¬O§_¦³¨ä¥L§ó¦³®Ä²v¤èªk¥i¥H°µ?
|