Î㤨¤Ð¥»¥ë3B¤Ë¤Ï7.3¡î¤È¤¤¤¦Ãͤ¬Æþ¤Ã¤Æ¤¤¤Þ¤¹¤¬¡¢¤³¤ÎÃͤÏWorksheets("¥·¡¼¥È̾").Cells(3,2)¤Ç»²¾È¤Ç¤¤Þ¤¹¡£
Cells(3,2)¤¬25¡î°Ê¾å¤Ê¤é¤ÐÊÌ¥·¡¼¥È¤ËµÆþ
Cells(4,2)¤¬25¡î°Ê¾å¤Ê¤é¤ÐÊÌ¥·¡¼¥È¤ËµÆþ
Cells(5,2)¤¬25¡î°Ê¾å¤Ê¤é¤ÐÊÌ¥·¡¼¥È¤ËµÆþ
¡Ä
¤È¤¤¤¦½èÍý¤ò·«¤êÊÖ¤»¤ÐÎɤ¤¤Î¤Ç¡¢
i = ºÇ½é¤Î¥Ç¡¼¥¿¤Î¹Ô ¡Á ºÇ¸å¤Î¥Ç¡¼¥¿¤Î¹Ô¤È¤·¤Æ¡¢
Cells(i,2)¤¬25¡î°Ê¾å¤Ê¤é¤ÐÊÌ¥·¡¼¥È¤ËµÆþ¡Ä¡Ê¢¨¡Ë
¤È¤¤¤¦½èÍý¤ò·«¤êÊÖ¤»¤ÐÎɤ¤¤³¤È¤¬¤ï¤«¤ê¤Þ¤¹¡£
¤³¤ì¤Ïforʸ¤Ç¼ÂÁõ¤Ç¤¤ë¤Ç¤·¤ç¤¦¡£
¾¤Î¥·¡¼¥È¤Ø¤ÎµÆþÊýË¡¤È¤·¤Æ¡¢
Worksheets("½ÐÎÏÀè").Cells(i,2) = Worksheets("½ÐÎϸµ").Cells(i,2)
¤È¤¤¤¦ÊýË¡¤¬»×¤¤¤Ä¤¤Þ¤¹¤¬¡¢¤³¤ì¤ò¼Â¹Ô¤¹¤ë¤Èµ¤»ý¤Á°¤¤¶õÍ󤬤Ǥ¤Þ¤¹¡£
¤Ê¤¼¤Ê¤é¡¢25¡î°Ê¾å¤Î¥Ç¡¼¥¿¤¬ i = 3, 5 ,7¤Î¾ì¹ç¡¢i=1, 2, 6¤Ê¤É¤Î¾ì½ê¤Ï½èÍý¤µ¤ì¤Ê¤¤¤«¤é¤Ç¤¹¡£
¤½¤³¤Ç¡¢¡Öº£¤¤¤¯¤Ä½ÐÎϤ·¤¿¤Î¤«¡×¤òµÏ¿¤¹¤ëÊÑ¿ô¤òÊÌÅÓÍÑ°Õ¤·¤Þ¤¹¡£
¤³¤ÎÊÑ¿ô¤òj=0¤È¤Ç¤âÄêµÁ¤·¤Æ¡¢¡Ê¢¨¡Ë¤òËþ¤¿¤¹¾ì¹ç¤Ëj¤ÎÃͤò°ì¤ÄÁý¤ä¤·¤Þ¤¹¡£
¤¹¤ë¤È¡¢ÊÌ¥·¡¼¥È¤ËµÆþ¤¹¤ë¤¿¤Ó¤Ëj= 1, 2, 3¡Ä¡¡¤ÈÁý¤¨¤ë¤Î¤Ç¡¢
Worksheets("½ÐÎÏÀè").Cells(j,2) = Worksheets("½ÐÎϸµ").Cells(i,2)¤È¤¹¤ì¤ÐåºÎï¤ËµÆþ¤Ç¤¤Þ¤¹¡£
¡ùȯŸ¡ù
Ëè²óWorksheets("½ÐÎÏÀè").Cells(i,2)¤È½ñ¤¯¤Î¤ÏÌÌÅݤʿͤϡ¢Worksheet·¿¤ÎÊÑ¿ô¤òÄêµÁ¤·¤Þ¤·¤ç¤¦¡£
Ä̾ï¤ÎÊÑ¿ô¤È°Û¤Ê¤ëÅÀ¤Ï¡¢ÂåÆþ»þ¤ËSet¤ò»È¤¦¤È¤³¤í¤Ç¤¹¡£
Îã¡Ë
Cells(3,2)¤¬25¡î°Ê¾å¤Ê¤é¤ÐÊÌ¥·¡¼¥È¤ËµÆþ
Cells(4,2)¤¬25¡î°Ê¾å¤Ê¤é¤ÐÊÌ¥·¡¼¥È¤ËµÆþ
Cells(5,2)¤¬25¡î°Ê¾å¤Ê¤é¤ÐÊÌ¥·¡¼¥È¤ËµÆþ
¡Ä
¤È¤¤¤¦½èÍý¤ò·«¤êÊÖ¤»¤ÐÎɤ¤¤Î¤Ç¡¢
i = ºÇ½é¤Î¥Ç¡¼¥¿¤Î¹Ô ¡Á ºÇ¸å¤Î¥Ç¡¼¥¿¤Î¹Ô¤È¤·¤Æ¡¢
Cells(i,2)¤¬25¡î°Ê¾å¤Ê¤é¤ÐÊÌ¥·¡¼¥È¤ËµÆþ¡Ä¡Ê¢¨¡Ë
¤È¤¤¤¦½èÍý¤ò·«¤êÊÖ¤»¤ÐÎɤ¤¤³¤È¤¬¤ï¤«¤ê¤Þ¤¹¡£
¤³¤ì¤Ïforʸ¤Ç¼ÂÁõ¤Ç¤¤ë¤Ç¤·¤ç¤¦¡£
¾¤Î¥·¡¼¥È¤Ø¤ÎµÆþÊýË¡¤È¤·¤Æ¡¢
Worksheets("½ÐÎÏÀè").Cells(i,2) = Worksheets("½ÐÎϸµ").Cells(i,2)
¤È¤¤¤¦ÊýË¡¤¬»×¤¤¤Ä¤¤Þ¤¹¤¬¡¢¤³¤ì¤ò¼Â¹Ô¤¹¤ë¤Èµ¤»ý¤Á°¤¤¶õÍ󤬤Ǥ¤Þ¤¹¡£
¤Ê¤¼¤Ê¤é¡¢25¡î°Ê¾å¤Î¥Ç¡¼¥¿¤¬ i = 3, 5 ,7¤Î¾ì¹ç¡¢i=1, 2, 6¤Ê¤É¤Î¾ì½ê¤Ï½èÍý¤µ¤ì¤Ê¤¤¤«¤é¤Ç¤¹¡£
¤½¤³¤Ç¡¢¡Öº£¤¤¤¯¤Ä½ÐÎϤ·¤¿¤Î¤«¡×¤òµÏ¿¤¹¤ëÊÑ¿ô¤òÊÌÅÓÍÑ°Õ¤·¤Þ¤¹¡£
¤³¤ÎÊÑ¿ô¤òj=0¤È¤Ç¤âÄêµÁ¤·¤Æ¡¢¡Ê¢¨¡Ë¤òËþ¤¿¤¹¾ì¹ç¤Ëj¤ÎÃͤò°ì¤ÄÁý¤ä¤·¤Þ¤¹¡£
¤¹¤ë¤È¡¢ÊÌ¥·¡¼¥È¤ËµÆþ¤¹¤ë¤¿¤Ó¤Ëj= 1, 2, 3¡Ä¡¡¤ÈÁý¤¨¤ë¤Î¤Ç¡¢
Worksheets("½ÐÎÏÀè").Cells(j,2) = Worksheets("½ÐÎϸµ").Cells(i,2)¤È¤¹¤ì¤ÐåºÎï¤ËµÆþ¤Ç¤¤Þ¤¹¡£
¡ùȯŸ¡ù
Ëè²óWorksheets("½ÐÎÏÀè").Cells(i,2)¤È½ñ¤¯¤Î¤ÏÌÌÅݤʿͤϡ¢Worksheet·¿¤ÎÊÑ¿ô¤òÄêµÁ¤·¤Þ¤·¤ç¤¦¡£
Ä̾ï¤ÎÊÑ¿ô¤È°Û¤Ê¤ëÅÀ¤Ï¡¢ÂåÆþ»þ¤ËSet¤ò»È¤¦¤È¤³¤í¤Ç¤¹¡£
Îã¡Ë
Dim data As Worksheet Set data = Worksheets("Data") data.Cells(1, 1) = ¡Ä
i = ºÇ½é¤Î¥Ç¡¼¥¿¤Î¹Ô ¡Á ºÇ¸å¤Î¥Ç¡¼¥¿¤Î¹Ô¤È¤·¤Æ
Cells(i, 2)¤òÁ´¤Æ¤·¤Æ¡¢Áí¿ô¤Ç³ä¤ê¤Þ¤·¤ç¤¦¡£
Áí¿ô¤ò¥«¥¦¥ó¥È¤¹¤ëÊÑ¿ô¤òÍÑ°Õ¤¹¤ë¤È¤è¤êÎɤ¤¤«¤È»×¤¤¤Þ¤¹¡£
Cells(i, 2)¤òÁ´¤Æ¤·¤Æ¡¢Áí¿ô¤Ç³ä¤ê¤Þ¤·¤ç¤¦¡£
Áí¿ô¤ò¥«¥¦¥ó¥È¤¹¤ëÊÑ¿ô¤òÍÑ°Õ¤¹¤ë¤È¤è¤êÎɤ¤¤«¤È»×¤¤¤Þ¤¹¡£
ºÇ¹â²¹Å٤ˤĤ¤¤Æ¹Í¤¨¤Þ¤¹¡£
¤Þ¤º¡¢ºÇ¹â²¹ÅÙ¤òµÏ¿¤¹¤ëÊÑ¿ô¤òÄêµÁ¤·¡Êmax¤È¤¹¤ë¡Ë¡¢¾®¤µ¤Ê¿ô¤òÂåÆþ¤·¤Æ¤ª¤¤Þ¤¹¡£
¤½¤·¤Æ¡ÖCells(i, 2)¤¬max¤è¤ê¤âÂ礤±¤ì¤Ð¡¡max=Cells(i,2)¤È¤¹¤ë¡×
¤È¤¤¤¦½èÍý¤ò·«¤êÊÖ¤»¤Ð¡¢ºÇÂçÃͤ¬Åо줹¤ë¤¿¤Ó¤Ëmax¤¬¾å½ñ¤¤µ¤ì¡¢ºÇ¸å¤ËºÇÂçÃͤ¬»Ä¤ê¤Þ¤¹¡£
¤½¤·¤Æ¡¢ºÇÂçÃͤ¬µÏ¿¤µ¤ì¤¿»þ¤Îi¤ÎÃͤâµÏ¿¤¹¤ë¤è¤¦¤Ë¤¹¤ì¤Ð¡¢¸å¤Ç(i,1)¤Î¤è¤¦¤ËÆüÉդˤ⥢¥¯¥»¥¹¤Ç¤¤Þ¤¹¡£
¤Þ¤º¡¢ºÇ¹â²¹ÅÙ¤òµÏ¿¤¹¤ëÊÑ¿ô¤òÄêµÁ¤·¡Êmax¤È¤¹¤ë¡Ë¡¢¾®¤µ¤Ê¿ô¤òÂåÆþ¤·¤Æ¤ª¤¤Þ¤¹¡£
¤½¤·¤Æ¡ÖCells(i, 2)¤¬max¤è¤ê¤âÂ礤±¤ì¤Ð¡¡max=Cells(i,2)¤È¤¹¤ë¡×
¤È¤¤¤¦½èÍý¤ò·«¤êÊÖ¤»¤Ð¡¢ºÇÂçÃͤ¬Åо줹¤ë¤¿¤Ó¤Ëmax¤¬¾å½ñ¤¤µ¤ì¡¢ºÇ¸å¤ËºÇÂçÃͤ¬»Ä¤ê¤Þ¤¹¡£
¤½¤·¤Æ¡¢ºÇÂçÃͤ¬µÏ¿¤µ¤ì¤¿»þ¤Îi¤ÎÃͤâµÏ¿¤¹¤ë¤è¤¦¤Ë¤¹¤ì¤Ð¡¢¸å¤Ç(i,1)¤Î¤è¤¦¤ËÆüÉդˤ⥢¥¯¥»¥¹¤Ç¤¤Þ¤¹¡£
¾åµ¼ê½ç¤ÇºÇÂçÃͤòµá¤á¤¿¤¢¤È¤ÇÁ´¤Æ¤Î¥Ç¡¼¥¿¤ò¤â¤¦°ìÅÙ¥Á¥§¥Ã¥¯¤·¡¢ºÇÂçÃͤÈƱ¤¸Ãͤò»ý¤ÄÆü¤òÁ´¤ÆÈ´¤½Ð¤·¤Þ¤·¤ç¤¦¡£
É®¼Ô¤ÏÆüÉդΥ»¥ë¤ò¥³¥Ô¡¼¤¹¤ë¤È¤¤Ë¡¢
to.Cells(i, 1) = from.Cells(i, 1)¤Î¤è¤¦¤Ê´¶¤¸¤Ç½ñ¤¤¤¿¤Î¤Ç¤¹¤¬¾å¼ê¤¯¤Ç¤¤Þ¤»¤ó¤Ç¤·¤¿¡£
¤½¤³¤Ç¥»¥ë¤ÎÃͤòÆüÉÕ·¿¤ËÊÑ´¹¤¹¤ëCDate´Ø¿ô¤ò»È¤Ã¤Æ¥¨¥é¡¼¤ò²óÈò¤·¤Þ¤·¤¿¡£
to.Cells(i, 1) = CDate(from.Cells(i, 1))
to.Cells(i, 1) = from.Cells(i, 1)¤Î¤è¤¦¤Ê´¶¤¸¤Ç½ñ¤¤¤¿¤Î¤Ç¤¹¤¬¾å¼ê¤¯¤Ç¤¤Þ¤»¤ó¤Ç¤·¤¿¡£
¤½¤³¤Ç¥»¥ë¤ÎÃͤòÆüÉÕ·¿¤ËÊÑ´¹¤¹¤ëCDate´Ø¿ô¤ò»È¤Ã¤Æ¥¨¥é¡¼¤ò²óÈò¤·¤Þ¤·¤¿¡£
to.Cells(i, 1) = CDate(from.Cells(i, 1))
f(x) = x + 4¤È¤¤¤¦´Ø¿ô¤òºî¤Ã¤Æ¤ß¤Þ¤¹¡Ê¤¿¤À¤·x¤Ï¼Â¿ô¡Ë¡£
¤½¤Î¸å¤ÎAs Double¤Ï¡¢¤³¤Î´Ø¿ô¤ÇÆÀ¤é¤ì¤ë¿ôÃÍ¡ÊÊÖ¤êÃ͡ˤ¬Double·¿¤Ç¤¢¤ë¤³¤È¤ò¼¨¤·¤Þ¤¹¡£
´Ø¿ôÆâ¤Ë¤É¤Î¤è¤¦¤Ê½èÍý¤ò½ñ¤¤¤Æ¤â¤¤¤¤¤Ç¤¹¤¬¡¢´Ø¿ô¤ÇÊÖ¤¹ÃͤÏf=x+4¤Î¤è¤¦¤Ë¡¢´Ø¿ô̾=¡Á¤Î·Á¤Ç½ñ¤¯É¬Íפ¬¤¢¤ê¤Þ¤¹¡£
¤Þ¤¿¡¢f(x, y) = x + y¤È¤¤¤¦´Ø¿ô¤Ï°Ê²¼¤Î¤è¤¦¤Ëºî¤ê¤Þ¤¹¡£
14, 15¥Ú¡¼¥¸¤Ë½ñ¤¤¤Æ¤¢¤ë¼öʸ¤ß¤¿¤¤¤Ê¿ô¼°¤ò´Ø¿ô²½¤¹¤ë¤È¡¢¥×¥í¥°¥é¥à¤¬¹½Â¤²½¤µ¤ì¤Æ´Ö°ã¤¤¤òõ¤·¤ä¤¹¤¯¤Ê¤ê¤Þ¤¹¡£
Function f(x As Double) As Double f = x + 4 End Functionx¤Î¸å¤ÎAs Double¤Ï¡¢x¤¬Double·¿¤Ç¤¢¤ë¤³¤È¤ò¼¨¤·¤Þ¤¹¡£
¤½¤Î¸å¤ÎAs Double¤Ï¡¢¤³¤Î´Ø¿ô¤ÇÆÀ¤é¤ì¤ë¿ôÃÍ¡ÊÊÖ¤êÃ͡ˤ¬Double·¿¤Ç¤¢¤ë¤³¤È¤ò¼¨¤·¤Þ¤¹¡£
´Ø¿ôÆâ¤Ë¤É¤Î¤è¤¦¤Ê½èÍý¤ò½ñ¤¤¤Æ¤â¤¤¤¤¤Ç¤¹¤¬¡¢´Ø¿ô¤ÇÊÖ¤¹ÃͤÏf=x+4¤Î¤è¤¦¤Ë¡¢´Ø¿ô̾=¡Á¤Î·Á¤Ç½ñ¤¯É¬Íפ¬¤¢¤ê¤Þ¤¹¡£
¤Þ¤¿¡¢f(x, y) = x + y¤È¤¤¤¦´Ø¿ô¤Ï°Ê²¼¤Î¤è¤¦¤Ëºî¤ê¤Þ¤¹¡£
Function f(x As Double, y As Double) As Double f = x + y End Function
14, 15¥Ú¡¼¥¸¤Ë½ñ¤¤¤Æ¤¢¤ë¼öʸ¤ß¤¿¤¤¤Ê¿ô¼°¤ò´Ø¿ô²½¤¹¤ë¤È¡¢¥×¥í¥°¥é¥à¤¬¹½Â¤²½¤µ¤ì¤Æ´Ö°ã¤¤¤òõ¤·¤ä¤¹¤¯¤Ê¤ê¤Þ¤¹¡£
- ¥«¥Æ¥´¥ê¡§
- ³ØÌ䡦Íý·Ï
- Áí¹ç
¥³¥á¥ó¥È¤ò¤«¤¯