| |||||
|
||
0
0
Àç´É°øÀ¯
»çÁø »ðÀÔÇÏ´Â ¸ÅÅ©·Î¸¦ »ç¿ëÁßÀÔ´Ï´Ù.
»ðÀÔÇÒ °÷ ¸¶¿ì½º·Î ¼±Åà ÈÄ ´ÜÃàÅ° ´©¸£¸é »çÁøÀ» °í¸£°í »çÁøÀÌ »ðÀÔµÇ°í »çÀÌÁî°¡ °¡·Î¼¼·Î 6.69 8.12 ·Î Á¶ÀýµË´Ï´Ù. ¿¢¼¿ 2000 »ç¿ëÇÏ´Ù°¡ 2010À¸·Î ¹Ù²Ù´Ï±î
¸ÅÅ©·Î°¡ µ¿ÀÛÀº Çϴµ¥ »çÁøÀÌ ¸µÅ©·Î °É·È´ÂÁö »çÁø»ðÀÔ µÈ ¿¢¼¿À» ´Ù¸¥pc¿¡¼ º¸¸é »çÁøÀÌ ¾È³ª¿É´Ï´Ù. ÇØ°á¹ý Á» ¾Ë ¼ö ÀÖÀ»±î¿ä?
************************************************************************
Dim ¼±ÅÃÆÄÀÏ As Variant
Dim ÆÄÀÏÇü½Ä As String Dim c As Range Set c = Selection On Error Resume Next ÆÄÀÏÇü½Ä = "±×¸² ÆÄÀÏ(*.jpg;*.png), *.jpg;*.png" ¼±ÅÃÆÄÀÏ = Application.GetOpenFilename(ÆÄÀÏÇü½Ä, Title:="±×¸² ¼±ÅÃ") If ¼±ÅÃÆÄÀÏ = False Then MsgBox "±×¸²À» ¼±ÅÃÇÏÁö ¾Ê¾Ò½À´Ï´Ù.", Title:="±×¸² »ðÀÔ" Else ActiveSheet.Pictures.Insert(¼±ÅÃÆÄÀÏ).Select With ActiveSheet.Shapes(Selection.Name) .LockAspectRatio = False .Top = c.Top .Left = c.Left .Height = 6.69 / 2.54 * 72 .Width = 8.12 / 2.54 * 72 .Placement = xlMoveAndSize End With End If ************************************************************************
ÇöÀç »ç¿ëÁßÀÎ ¼Ò½º ÀÔ´Ï´Ù.
2019-10-14
|
0
1
¾ÐµµÀû¸íÇ°
2010 ºÎÅÍ À§ ÇüÅÂÀÇ À̹ÌÁö »ðÀÔ ·ÎÁ÷ÀÌ Link·Î º¯°æµÇ¾î ±×·¸½À´Ï´Ù.
¾Æ·¡ ¼Ò½º·Î ¼öÁ¤Çؼ »ç¿ëÇغ¸¼¼¿ä.
Å×½ºÆ®¸¦ Çغ¸Áø ¾Ê¾ÒÀ¸´Ï Ȥ½Ã ¿À·ù°¡ ÀÖ´Ù¸é ´Ù½Ã ´ñ±Û ´Þ¾ÆÁÖ¼¼¿ä
Dim ¼±ÅÃÆÄÀÏ As Variant
Dim ÆÄÀÏÇü½Ä As String Dim c As Range Dim s As Shape Set c = Selection On Error Resume Next ÆÄÀÏÇü½Ä = "±×¸² ÆÄÀÏ(*.jpg;*.png), *.jpg;*.png" ¼±ÅÃÆÄÀÏ = Application.GetOpenFilename(ÆÄÀÏÇü½Ä, Title:="±×¸² ¼±ÅÃ") If ¼±ÅÃÆÄÀÏ = False Then MsgBox "±×¸²À» ¼±ÅÃÇÏÁö ¾Ê¾Ò½À´Ï´Ù.", Title:="±×¸² »ðÀÔ" Else Set s = ActiveSheet.Shapes.AddPicture(¼±ÅÃÆÄÀÏ, False, True, c.Left, c.Top, 8.12 / 2.54 * 72, 6.69 / 2.54 * 72) s.Placement = xlMoveAndSize s.LockAspectRatio = False End If
2019-10-14
|
0
0
Àç´É°øÀ¯
=IF(sheet2!$G$24=4,TEXT(sheet2!$G$20,"0.000 00"),IF(sheet2!$G$24=5,TEXT(sheet2!$G$20,"0.000 000"),IF(sheet2!$G$24=6,TEXT(sheet2!$G$20,"0.000 000 0"),IF(sheet2!$G$24=7,TEXT(sheet2!$G$20,"0.000 000 00"),IF(sheet2!$G$24=8,TEXT(sheet2!$G$20,"0.000 000 000"),IF(sheet2!$G$24=9,TEXT(sheet2!$G$20,"0.000 000 000 0"),IF(sheet2!$G$24=10,TEXT(sheet2!$G$20,"0.000 000 000 00"),"ERROR")))))))&" "&sheet2!$I$20&" "
À§¿Í °°ÀÌ ÇÑ°³ÀÇ ¼¿¿¡ IF ÇÔ¼ö¸¦ ¿©·¯°³ »ç¿ëÇÏ¿´½À´Ï´Ù. ( ´õ Ãß°¡ÇØ¾ß ÇÏÁö¸¸ ºÎÁ·ÇÔ )
¸ÅÅ©·Î¸¦ »ç¿ëÇÑ´Ù¸é FOR ¹®À¸·Î ½±°Ô µÉÅÙµ¥, ¸ÅÅ©·Î¸¦ »ç¿ëÇÏ¸é ¾ÈµÇ´Â ¿¢¼¿ÆÄÀÏ ÀÔ´Ï´Ù.
IF Á¶°ÇÀ» ´õ Ãß°¡ ÇؾßÇϴµ¥ ¿¢¼¿¿¡¼ IF °¹¼ö Á¦ÇÑÀÌ ÀÖ´ÂÁö »ç¿ëÀÌ ¾ÈµË´Ï´Ù.
Ȥ½Ã ¿¢¼¿¿¡ FOR¹® °°Àº ÇÔ¼öµµ ÀÖ³ª¿ä?
======================================================
ÇöÀç »ç¿ëÁßÀÎ ¿¢¼¿ 2016¿¡¼ ÄÁÆ®·Ñ + P Àμ⠹̸®º¸±â°¡ °¡´ÉÇÕ´Ï´Ù.
Àμ⠹̸®º¸±â¿¡¼´Â ÁÂÃø¿¡´Â Àμ⼳Á¤ ¿ìÃø¿¡´Â A4 »çÀÌÁî·Î ¹Ì¸®º¸±â ³ª¿É´Ï´Ù.
Àμ⼳Á¤ ¾Èº¸°í ¹Ì¸®º¸±â¸¸ µü ÇÏ´Â ±â´ÉÀº ¾ø³ª¿ä? (¿¢¼¿ 2000¿¡¼´Â µü Ãâ·ÂµÇ´Â°Í¸¸ ¹Ì¸®º¸±â°¡ µÇ¾ú½À´Ï´Ù.)
2019-10-14
|
0
0
¾ÐµµÀû¸íÇ°
1. ÇÔ¼ö¿¡¼ FOR¹®À» »ç¿ëÇÒ ¼ø ¾ø½À´Ï´Ù 2. IF¹®ÀÇ ÁßøÀº 64°³±îÁö °¡´ÉÇÕ´Ï´Ù¸¸, 3°³¸¸ Áßø °ü¸®°¡ ¾î·Á¿öÁö¹Ç·Î ´Ù¸¥ ¹æ¹ýÀ» ÃßõÇÕ´Ï´Ù. 3. À§ ÇüÅÂÀÇ IF¹®Àº ´Ù¸¥ ¿©·¯°¡Áö ¹æ¹ýÀ¸·Î ´ëüÇÒ ¼ö ÀÖ½À´Ï´Ù.
G24 = 4ÀÏ°æ¿ì ¤·¤·¤·, 5ÀÏ°æ¿ì ¤·¤·¤·, 6ÀÏ°æ¿ì ¤·¤·¤· À§ ³í¸®¿Í °°Àº ƯÁ¤¼¿ÀÇ °ªÀÌ ÀÚ¿¬¼öÀÌ¸é¼ 1~¼ö½Ê À̳»ÀÇ °æ¿ì =CHOOSE ÇÔ¼ö¸¦ ÃßõÇÕ´Ï´Ù EX) =CHOOSE(A1,"¿ù","È","¼ö","¸ñ","±Ý","Åä","ÀÏ") A1ÀÌ 1ÀÌ¸é ¿ù, 2À̸é È, 3ÀÌ¸é ¼ö ...... 7À̸é ÀÏ ¸¸¾à ¼ýÀÚÀÇ ¹üÀ§°¡ ³Ê¹« Å©´Ù¸é VLOOKUP À» È°¿ëÇϼ¼¿ä º°µµÀÇ ½ÃÆ®¿¡ A¿¿¡´Â ºñ±³ÇÒ ¼ýÀÚ(ex, A1Àº 4, A2´Â 5, A3Àº 6 µî...) ±×¸®°í B¿¿¡´Â Ç¥½ÃÇÒ °ªÀ» ÇÔ¼ö·Î Àû¾îµÎ¼¼¿ä( TEXT(sheet2!$G$20,"0.000 00") ¿Í °°Àº..) ±×·¯¸é =vlookupÀ¸·Î ¶¯°Ü¿À¸é ¿øÇÏ´Â °á°ú¸¦ ¹Ù·á Ç¥½ÃÇÒ ¼ö Àְڳ׿ä.. ÀÌ ¿Ü¿¡µµ ¹æ¹ýÀº ¹«±Ã¹«ÁøÇÕ´Ï´Ù.
°ø½Ä´äº¯Àº ¾Æ·¡ ¸µÅ©¸¦ Âü°í ¹Ù¶ø´Ï´Ù.
2019-10-14
|
0
0
Àç´É°øÀ¯
¿Í ¿ª½Ã ÇÔ¼ö´Â ÀÀ¿ëÀÌ³×¿ä ´Ù¸¥¹æ¹ýµé ¾Ë·ÁÁּż °¨»çÇÕ´Ï´Ù. °øºÎÁ» ´õ Çؼ Àû¿ëÇغÁ¾ß°Ú³×¿ä~~
Ȥ½Ã Àμâ¹Ì¸®º¸±â¿¡¼ Àμ⼳Á¤ ¾øÀÌ º¸°Å³ª ´Ù¸¥ ¹Ì¸®º¸±â ¹æ¹ý ¾Ë°í°è½Å´Ù¸é ºÎŹµå¸³´Ï´Ù...
2019-10-14
|
0
0
¹°¸¸µÎ
¿ÀÇǽº 2010 32bit ¹öÀü ½ÃÀý¿¡ ÀÛ¼ºÇÑ ¿¢¼¿ vba ÇÁ·Î±×·¥µéÀÌ ¿ÀÇǽº 2016 64bit ±ò°í ¿¢¼¿ÄѼ ½ÇÇàÇß´õ´Ï ¿ÜºÎ ÂüÁ¶ ÇÔ¼öµéÀÌ ¿¡·¯ ´Ù °É¸®°í »¸¾î¹ö¸³´Ï´Ù. ÀÌ·± °æ¿ì ¿¡·¯ ³ªÁö ¾Êµµ·Ï ÀÏ°ý conversion ÇÏ´Â ¹æ¹ý ÀÖ´ÂÁö¿ä?
2019-10-14
|
0
1
¾ÐµµÀû¸íÇ°
ÀÏ°ý ÄÁ¹öÀüÀº ¾ø½À´Ï´Ù. ª°Ô ¸»¾¸µå¸®¸é ¿ÀÇǽº 32bit¾²¼¼¿ä ¸¶ÀÌÅ©·Î¼ÒÇÁÆ® °ø½Ä´äº¯¿¡¼µµ 32bit ÃßõÇÕ´Ï´Ù
2019-10-14
|
0
0
¹°¸¸µÎ
¿À ÁÁÀº Á¶¾ð °¨»çÇÕ´Ï´Ù. ±×³É ¼ÓÆíÇÏ°Ô °í¹Î¸»°í ±×·¸°Ô Çؾ߰ڳ׿ä.
2019-10-14
|
0
0
¹°¸¸µÎ
@¾ÐµµÀû¸íÇ° ¿äÁò ´Ù½Ã ¾Ë¾Æº¸´Ï PtrSafe ±¸¹® »ðÀÔ ÀÌ¿ëÇÏ¸é °£´ÜÇϳ׿ä.
32bit °è¼Ó »ç¿ëÇÏÀÚ´Ï ¿äÁò ´Ù 64bit °¡´Â Ãß¼¼ÀÌ°í, VBAµµ ¿ÀÇǽº 64bit »ç¿ëÇÏ´Â°Ô ·¥ È°¿ë Ãø¸é¿¡¼ ´õ ³´´Ù°í Çϳ׿ä.
¸çÄ¥Àü¿¡ 64ºñÆ® ¿ÀÇǽº ¼³Ä¡ ÈÄ PtrSafe »ðÀÔÀ¸·Î ±âÁ¸ VBAÄÚµå Àû¿ë ÀÏ°ý ÄÁ¹öÀü °£´ÜÈ÷ ÇØ°áÇß½À´Ï´Ù.
Ȥ½Ã °Ë»öÀ¸·Î À¯»çÇÑ ³»¿ë ã´Â ºÐµéÀ» À§ÇØ ´ñ±Û Çǵå¹é ³²±é´Ï´Ù. Âü°íÇϽʽÿÀ.
2021-06-28
|
0
0
¿õ¶óÀú¸®Áö
¿¢¼¿ÀÌ º¹ÀâÇÒ°æ¿ì Á¦°¡ Ŭ¸¯ÇÏ°í ÀÖ´Â ¼¿ÀÌ ¾îµð¿¡ À§Ä¡ÇÏ°í ÀÖ´ÂÁö È®ÀÎÀÌ ¾î·Æ½À´Ï´Ù. Ȥ½Ã ³»°¡ Ŭ¸¯ÇÏ°í ÀÖ´Â ¼¿ÀÇ ¼½ÄÀ» ¹Ù²Ü¼öµµÀÖ³ª¿ä?
2019-10-14
|
0
0
¾ÐµµÀû¸íÇ°
°¡´ÉÇÕ´Ï´Ù
¾Æ·¡ ±¸±Û¸µ °á°ú¸¦ Âü°íÇÏ½Ã¸é µÉ µí ÇÕ´Ï´Ù
2019-10-14
|
0
0
¾ÐµµÀû¸íÇ°
15³âÀü¿¡ µý ÀÌÈÄ °ü·Ã Ã¥À» º» ÀûÀÌ ¾ø¾î¼¿ä ¼Àû °ü·Ã Áú¹®¿¡ ´ëÇÑ °øÅë ´äº¯Àº ÁýÁß·ÂÀÌ ÁÁ°í ²ö±â°¡ ÀÖ´Ù = µÎ²¨¿î ¹é°ú»çÀü°°Àº Ã¥ ÁýÁß·ÂÀÌ ¾àÇÏ°í ²ö±â°¡ ¾ø´Ù = ±×¸² ¸¹Àº ¾ãÀº Ã¥ ´ëºÎºÐ ÈÄÀÚ¶ó ¾ãÀº Ã¥À» ÃßõÇÕ´Ï´Ù. ¿Ö³Ä...¿¿¡ ¾ÆÈ©Àº Áß°£¿¡ Æ÷±âÇϰŵç¿ä ´Ù ÀÐÀ» ¼ö ÀÖ´ÂÃ¥ÀÌ ÁÁÀº Ã¥À̶ó »ý°¢ÇÕ´Ï´Ù
2019-10-14
|
0
0
¾Æ·»Æ¼
¸®½ºÆ®ºä¿Í Æ®¸®ºä¸¦ Àß »ç¿ëÇÏ°íÀÖ¾ú´Âµ¥ 64ºñÆ®¿ëÀÌ ¾ø½À´Ï´Ù...¤Ð
ÃßõÇØÁֽǸ¸ÇÑ ¹æ¹ýÀ̳ª ocx°¡ ÀÖÀ»±î¿ä??
2019-10-14
|
0
0
¾ÐµµÀû¸íÇ°
Àú´Â ¸ðµç ȯ°æ¿¡ ´ëÀÀÇÒ ¼ö ÀÖ´Â °øÅë ¸ðµâÀ» ¸¸µå´Â »ç¶÷À̶ó... ÀϺη¯ ±âº»±â´ÉÀÎ listbox¸¦ È°¿ëÇÕ´Ï´Ù. ºÎÁ·ÇÑ ±â´ÉÀº ¸¸µé¾î¼ È°¿ëÇÏ¸é ¾óÃß ºñ½ÁÇØÁý´Ï´Ù!
2019-10-14
|
0
0
½ºÅö¸Ç
¿¢¼¿ ÁøÂ¥ ½Ç¹«ÀÚÁ¤µµ·Î ¹è¿ì·Á¸é ¾î¶² ·çÆ® ÃßõÇØÁֽóª¿ä¤Ð
2019-10-14
|
0
0
´íÀÔ´Ï´ç
Àúµµ ±Ã±ÝÇØ¿ä
2019-10-14
|
0
0
MadridDerby
Àúµµ ±Ã±ÝÇÕ´Ï´Ù!
2019-10-14
|
0
0
¾ÐµµÀû¸íÇ°
1. ȸ»ç »ç¼öÇÑÅ× ¹è¿î´Ù
2. 1´ë1 °ú¿Ü¸¦ ¹Þ´Â´Ù 3. ´Üü °ÀǸ¦ µè´Â´Ù
1~3À¸·Î ¹è¿öºÃÀÚ °³³ä¸¸ ÀÍÈ÷°Ô µÇ¹Ç·Î ¹«ÇÑ ¿¬½ÀÀ» ÅëÇØ ½ÃÇàÂø¿À¸¦ °Þ¾î ³»°ÍÀ¸·Î ¸¸µç´Ù
2019-10-14
|
0
0
¹è°íÇÁ¸é¹°¸¶¼Å
Æã¼ÇÅ°°¡ ¾î¶³¶§´Â Àß ´¸®´Ù°¡ ¾î¶³¶§´Â ¾ÈµÇ´Âµ¥.. ÀÌ°Å.È°¼ºÈ ºñÈ°¼ºÈ ¹æ¹ýÀÌ ÀÖ³ª¿ä..
2019-10-14
|
0
0
¾ÐµµÀû¸íÇ°
Àú´Â °æÇèÇغ¸Áö ¸øÇÑ Áõ»óÀ̶ó.. Å°º¸µå ¹®Á¦ ¾Æ´Ò±î¿ä?
2019-10-14
|
0
0
Äɸ®Áø
ÃÖ½ÅÆÇ ±âÁØÀ¸·Î ¿¢¼¿ µ¥ÀÌÅÍ ´ãÀ» ¼ö ÀÖ´Â ÃÖ´ë ·Î¿ì´Â ¸î°³Àΰ¡¿ä?
2019-10-14
|
0
0
¾ÐµµÀû¸íÇ°
xls(¿¢¼¿ 97)Àº 65536Çà
xlsx(2003 ÀÌÈÄ)´Â 1048576Çà(¾à 100¸¸)
´ëºÎºÐ xlsx µîÀ» ¾²¹Ç·Î 100¸¸ÇàÀÌ¶ó º¸½Ã¸é µË´Ï´Ù
2019-10-14
|
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | -¸ñ·Ïº¸±â |
Áú¹®À» Á¤È®È÷ ÀÌÇØÇÏÁö ¸øÇß½À´Ï´Ù. ¿¹½Ã¸¦ µé¾îÁÖ½Ã¸é ´õ ÁÁÀ» °Í °°Áö¸¸
ÀÏ´Ü Á¦°¡ ÀÌÇØÇÑ´ë·Î¸¸ ´äº¯À» ÇÑ´Ù¸é
¼ö½ÄÀ» ºÐÇØÇÑ´Ù, ¼ö½ÄÀÇ ÀϺθ¦ ¹Ì¸® °è»êÇÏ°í ½Í´Ù·Î ÀÌÇØÇߴµ¥
=SUM(A1,B1,C1) ¿¡¼ A1 TEXT¸¸ µå·¡±×Çؼ F9 ¸¦ ´©¸£¸é 'A1' ¹®ÀÚ°¡ A1 ¼¿ÀÇ °ªÀ¸·Î º¯È¯µË´Ï´Ù.
=INDEX(¾î¼±¸,MATCH(Àú¼±¸) ¿¡¼ MATCH(Àú¼±¸)¸¸ µå·¡±× Çؼ F9 ´©¸£¸é MATCH ÇÔ¼öÀÇ °è»ê °á°ú·Î º¯È¯µÇ±¸¿ä
F9´Â µå·¡±×ÇÑ ÇÔ¼ö¸¦ Áï½Ã °è»êÇؼ °ªÀ¸·Î Ç¥ÇöÇØÁÖ´Ï, ±ä~ ¼ö½ÄÀ» ºÐ¼®ÇÒ¶§ ±²ÀåÈ÷ À¯¿ëÇÕ´Ï´Ù.
ÀÌ ´äº¯À» ¿øÇÏ½Ç Áø ¸ð¸£°ÚÀ¸³ª, ÀϹÝÀûÀ¸·Î ÀÌ ´äº¯À» À¯¿ëÇÏ°Ô »ç¿ëÇϽô ´Ù¸¥ ºÐµéÀÌ °è¼Å¼ ´Þ¾Æº¾´Ï´Ù.
´Ù¸¥ ³»¿ëÀ̶ó¸é ¿¹½Ã¸¦ µé¾î¼ Á¶±Ý ´õ ±¸Ã¼ÀûÀ¸·Î Áú¹® ºÎŹµå·Á¿ä.