ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

MAX°ÝÃD

MAX°ÝÃD

·Qª¾¨ì3­Ó¼Æ³Ì¤jªº¼Æ.

MY1 = 1
MY2 = 2
MY3 = 3

MYMAX = Max(MY1, MY2, MY3)

½Ð°Ý¿ù¤F¨º»ò?><
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# basarasy
MYMAX = Application.Max(MY1, MY2, MY3)

TOP

ÁÂÁÂGBKEEª©¥D
¬O§_VBA¤º¥Îªº³£­n¥[Application?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¨Ï¥Îªº¬Ovba¨ç¼Æ¤£¥Î¥[¡C
­Y¨Ï¥Îªº¬O¤u§@ªí¨ç¼Æ´N­n¡C

TOP

§¹¾ãªº¼gªk¬O³o¼Ëªº
Application.WorksheetFunction.Max(Range("A1:A10"))
³o¸Ì"WorksheetFunction"§Ú­Ì¥i¥H¬Ý¨ì¬O¨Ï¥Î¤u§@ªí¨ç¼Æ~

²¼gªº¸Ü ¥ç¥i¹³GBKEE¥S Application.Max()
­Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I                  
­Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I

TOP

©ú¥Õ
EXCEL¯uªº¦³¦n¦hªF¦è¾Ç.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD