[ ‰‚ß‚Ä‚Ì•û‚Ö | ˆê——(ÅVXV‡) | ‘S•¶ŒŸõ | ‰ß‹ŽƒƒO ]
@
w¤•i—ñ‚Ì“ü‚ê‘Ö‚¦xi”z‘—ŒWj
C—ñ D—ñ E—ñ F—ñ G—ñ H—ñ I—ñ J—ñ K—ñ L—ñ 4s–Ú ‹Ê”K ‚¿‚À‚݃zƒEƒŒƒ“‘ H”n—é’ ’·ˆð ƒXƒiƒbƒNƒGƒ“ƒh ƒLƒƒƒxƒc ƒgƒ}ƒg. ”’ Ë ƒyƒeƒgƒ}ƒg ˜@ ª 5s–Ú ‚Ô‚È‚µ‚ß‚¶ ˆÀ”[ˆð –¡•½“ì‰Z ƒJƒbƒg–ìØ ŠÃ“ ƒTƒj[ƒŒƒ^ƒX ƒTƒ\ƒLƒƒƒxƒc ƒŒƒ^ƒX ”’”K —A“üƒAƒXƒpƒ‰ 6s–Ú •‘‘ù ‚±‚¾‚í‚è¬¼Ø ƒOƒŠ[ƒ“ƒŠ[ƒt ‘å ª ’·‰ÖŽq. ‚Ù‚¤‚ê‚ñ‘ ‚‚è‚䂽‚©“ì‰Z ƒ~ƒj”K ƒs[ƒ}ƒ“ ‰©‹à¶›I 7s–Ú ƒuƒƒcƒRƒŠ[ ƒZƒ‹ƒŠ[ ƒiƒƒR ‰©ŽÝ”n—é’ ¬¼Ø ‚¦‚è‚ñ‚¬ ŒÓ‰Z lŽQ ¶’Å‘ùi‹Û°j Ô”ü–¡ƒ~ƒjƒgƒ}ƒg 8s–Ú ƒGƒmƒL ƒJƒŠƒtƒ‰ƒ[ ‹ãð‚Ë‚¬ ¶’Å‘ùiŒ´–Øj —¢ˆð ƒ~ƒfƒB[ƒgƒ}ƒg …Ø ‹àŽžŠÃ“ ƒuƒ‰ƒEƒ“ƒ}ƒbƒVƒ… ƒ}ƒbƒVƒ…ƒ‹\ƒ€ ƒfƒRƒ{ƒR‚ÅŒ©‚Â炢‚Ì‚Å‚·‚ª‚¨Šè‚¢‚µ‚Ü‚·B C—ñ‚Ss–Ú‚©‚çL—ñ‚Ws–ڂ܂Ť•i–¼‚ª•À‚ñ‚Å‚¢‚Ü‚·B ˆê—ñ–ˆ‚̤•i‚Ì•À‚Ñ‚Í•Ï‚¦‚¸‚É“ü‚ê‘Ö‚¦‚½‚¢‚Ì‚Å‚·‚ª‚Å‚«‚é‚Å‚µ‚傤‚©?
ƒ Žg—p ExcelFExcel2013AŽg—p OSFWindows7 „
‚Ç‚¤‚¢‚¤‡”Ô‚É•À‚בւ¦‚½‚¢‚©‚Ìà–¾‚ª‚ ‚è‚Ü‚¹‚ñ‚ªAì‹ÆƒV[ƒg‚ňê‰ñs—ñ“ü‚ê‘Ö‚¦‚Ä‚©‚ç •À‚בւ¦‚ÄAÄ“xAs—ñ“ü‚ê‘Ö‚¦‚Å‚Í‚Å‚«‚È‚¢‚Å‚µ‚傤‚©B
http://shikaku.biglobe.ne.jp/pc_technic/excel/03_1.html
iMookj 2015/01/10(“y) 15:21
VBA @ InputBox‚ªoŒ»‚µ‚½‚çA‘S—ñ‚Ì‘Š‘ÎŽQÆ’li‚±‚Ìê‡C—ñ‚ª 1 D—ñ‚ª@2...)@‚ð Šó–]‚·‚釔ԂɃRƒ“ƒ}‚Å‹æØ‚Á‚Ä“ü—ÍB —áF 1,2,4,5,3,7,6,8,9,10,11
Sub test() Dim x x = Split(InputBox("‘Š‘Ηñ‡‚Ì“ü—Í" & vbLf & "—á: 3,2,1,4,5"), ",") With Range("c4:l8") If UBound(x) <> .Columns.Count - 1 Then MsgBox "—ñ”‚Æ“ü—Í’l‚ª‡‚¢‚Ü‚¹‚ñ" Else .Value = Application.Index(.Value, Evaluate("row(1:" & .Rows.Count & ")"), x) End If End With End Sub
iseiyaj 2015/01/10(“y) 15:45
ƒ`ƒ‡ƒCC³GŽQÆ—ñ‚Ìà–¾ 16:21
“ü‚ê‘Ö‚¦‘O‚ÆA“ü‚ê‘Ö‚¦Œã‚Ì•\‚ðÚ‚µ‚•\Ž¦‚µ‚Ä‚à‚炦‚Ü‚¹‚ñ‚©H iseiyaj 2015/01/10(“y) 18:51
‰¡‚©‚玸—炵‚Ü‚·B
uŽ–—Ⴊˆá‚Á‚Ä‚¨‚è‚Ü‚·BvEE‚ ‚Ü‚è‚É‚ày–Ø‚Å•@‚ð‚‚‚Á‚½‚悤‚ÈzƒŒƒX‚Å‚·‚Ë‚¥EE ‚µ‚©‚àAuŽ–—á‚Í‚ ‚Á‚Ä‚Ü‚·‚æIv
ˆÈ‰º‚Ì‘€ì‚Ìꊂɂ‚¢‚Ä‚ÍAŽÀÛ‚É‘€ì‰Â”\‚ȗ̈æ‚É•ÏX‚µ‚Ä‚‚¾‚³‚¢B
‚PDC3:C8‚ð‘I‘ð‚µ‚Ä Ctrl/c ‚QDO1‚ð‘I‘ð‚µ‚ÄAŒ`Ž®‚ð‘I‘ð‚µ‚Ä“\‚è•t‚¯@‚Ì@s—ñ‚ð“ü‚ê‘Ö‚¦‚é@‚ðƒ`ƒFƒbƒN‚µ‚ÄŽÀs ‚RDN1`N10@‚É@‚»‚ꂼ‚ê‚̃f[ƒ^‚Ì•\Ž¦Šó–]‡‚ð 1@` 10 ‚Å‚¢‚ê‚éB ‚SDN1:S10 ‚ð‘I‘ð‚µ‚Ä@N—ñ‚Å•À‚Ñ‘Ö‚¦ ‚TD•À‚Ñ‘Ö‚¦‚ç‚ꂽ O1:S10 ‚ð‘I‘ð‚µ‚Ä Ctrl/c ‚UDC3 ‚ð‘I‘ð‚µ‚ÄAŒ`Ž®‚ð‘I‘ð‚µ‚Ä“\‚è•t‚¯@‚Ì@s—ñ‚ð“ü‚ê‘Ö‚¦‚é@‚ðƒ`ƒFƒbƒN‚µ‚ÄŽÀs
iƒÀj 2015/01/10(“y) 18:54
‚Æ‚©‚Å‚¢‚¢‚ñ‚¶‚á‚È‚¢‚Å‚·‚©B iƒRƒiƒ~j 2015/01/10(“y) 19:03
2013‚È‚çˆÈ‰º‚̎臂łàB
‚PDC3:L3 ‚ÉŠó–]•\Ž¦‡‚ð‚¢‚ê‚é ‚QDC3:L8 ‚ð‘I‘ð‚µ‚Ä•À‚Ñ‘Ö‚¦ @@‚Pjƒ†[ƒUÝ’è‚Ì•À‚Ñ‘Ö‚¦ @@‚QjƒIƒvƒVƒ‡ƒ“ @@‚Rj—ñ’PˆÊ‚ð‘I‚Ô @@‚Sj•À‚Ñ‘Ö‚¦‰æ–Ê‚ÅAÅ—D悳‚ê‚éƒL[@‚ð@s3 ‚É‚µ‚ÄŽÀs
iƒÀj 2015/01/10(“y) 19:13
ƒRƒiƒ~—l
‚Ü‚³‚ɃRƒŒ‚Å‚·B
Žèì‹Æ‚Å‚â‚邵‚©Žè‚Í‚È‚¢‚Æ‚¢‚¤‚±‚Æ‚Å‚µ‚傤‚©B
i”z‘—ŒWj 2015/01/11(“ú) 18:06
‚¢‚âAƒÀ‚³‚ñ‚ª—ñ•ûŒü‚Ì•À‚בւ¦‚̎臂𠑂¢‚Ä‚‚ê‚Ä‚Ü‚·‚æB ‚Ü‚¸‚Í‘‚©‚ê‚Ä‚¢‚é’Ê‚è‚É‚â‚Á‚Ä‚Ý‚Ä‚Í”@‰½‚Å‚µ‚傤‚©H iƒRƒiƒ~j 2015/01/11(“ú) 20:48
‚±‚ñ‚΂ñ‚Í
‚±‚̂悤‚ÈŽ–‚Å‚µ‚傤‚©H
•W€ƒ‚ƒWƒ…[ƒ‹‚É“\‚è•t‚¯‚Ä‚‚¾‚³‚¢B
Const v As Long = 12 Const “ü‚ê‘Ö‚¦‡ As String = ",1,2,5,3,9,7,8,12,10,6,4,11"
Sub —ñ‚Ì“ü‚ê‘Ö‚¦() Application.ScreenUpdating = False Cells.Replace vbLf, ":"
Dim —ñ(v) As Range Dim C“ü‚ê‘Ö‚¦ As Variant Dim i As Long
For i = 1 To v Set —ñ(i) = Columns(i) Next
C“ü‚ê‘Ö‚¦ = Split(“ü‚ê‘Ö‚¦‡, ",")
For i = 1 To v If —ñ(C“ü‚ê‘Ö‚¦(i)).Column <> i Then —ñ(C“ü‚ê‘Ö‚¦(i)).Cut Columns(i).Insert xlShiftToRight End If Next
End Sub
i‚f999j 2015/01/13(‰Î) 02:33
3s–Ú‚É•À‚т̇”Ô‚ð”’l‚Å“ü—ÍB
B4`L8‘I‘ð‚µ‚Ä—ñ’PˆÊ‚Ÿ‡•À‚Ñ‘Ö‚¦B @ iGobGobj 2015/01/13(‰Î) 07:55
i”z‘—ŒWj 2015/01/14(…) 21:24
VBAˆ—ˆÄƒAƒbƒv‚µ‚Ü‚µ‚½‚ªA‚¢‚Á‚½‚ñ휂µ‚Ü‚·B
iƒÀj 2015/01/15(–Ø) 07:59
ÄŒf‚µ‚Ü‚·B ŽÀۂ̃f[ƒ^—̈æ‚Ì‚Psã‚É—ñŠó–]‡‚ð 1 ‚©‚ç“ü—Í‚µ‚Ä‚¨‚«A‚»‚ÌŠó–]‡s‚àŠÜ‚ß‚Ä@šˆó‚̗̈æ‚ðŠù’肵‚Ä‚‚¾‚³‚¢B ‚©‚È‚èŽè”²‚«‚ð‚µ‚Ä‚¢‚Ü‚·‚µA‚Ü‚½A‚½‚Æ‚¦‚Î 1,2,3 ‚Ü‚ÅŽw’èA‚»‚Ì‚Ù‚©‚ÍAŒ»Ý‚Ì—ñ‡‚Æ‚¢‚¤‚±‚Æ‚à‚Å‚«‚Ü‚·‚ª ‚Æ‚è‚ ‚¦‚¸‚Í@‚·‚ׂĂ̗ñ‚ÌŠó–]‡‚ð‚¢‚ê‚ÄŽŽ‚µ‚Ä‚Ý‚Ä‚‚¾‚³‚¢B
Sub Test() Dim dic As Object Dim j As Long Dim Target As Range
Set dic = CreateObject("Scripting.Dictionary")
Set Target = Range("C3:L8") 'š
For j = 1 To Target.Columns.Count dic(j) = "" Next
For j = 1 To Target.Columns.Count dic(Target.Cells(1, j).Value) = Application.Transpose(Target.Columns(j).Value) Next
Target.Value = Application.Transpose(dic.items)
End Sub
iƒÀj 2015/01/15(–Ø) 08:40
Žè”²‚«‚ð‚µ‚Ä‚¢‚½—ñŠó–]‡“ü—͂̃`ƒFƒbƒN‚ð‰Á‚¦A‚ ‚킹‚Ä@Šó–]‡‚ªŽw’肳‚ê‚Ä‚¢‚È‚¢—ñ‚ɂ‚¢‚Ä‚Í Šó–]‡Žw’è‚Ì—ñ‚ÌŒã‚ë‚ÉAŒ»s—ñ‡‚ŃZƒbƒg‚·‚é•”•ª‚ð’ljÁB‚²ŽQl‚Ü‚ÅB
Sub Test2() Dim dic As Object Dim j As Long Dim Target As Range Dim x As Long Dim y As Long Dim z As Long Dim erFlag As Boolean Dim adr As String
Set Target = Range("C3:L8") 'š
'Šó–]‡s‚̃`ƒFƒbƒN adr = Target.Rows(1).Address x = WorksheetFunction.CountA(Target.Rows(1)) y = WorksheetFunction.CountBlank(Target.Rows(1)) If x + y <> Target.Columns.Count Then erFlag = True If WorksheetFunction.Min(Target.Rows(1)) <> 1 Then erFlag = True If WorksheetFunction.Max(Target.Rows(1)) > x Then erFlag = True z = Evaluate("=SUM(IF(FREQUENCY(" & adr & "," & adr & ")>0,1))") If z <> x Then erFlag = True
If erFlag Then MsgBox "Šó–]‡‚ÌŽw’肪³‚µ‚‚ ‚è‚Ü‚¹‚ñ" Exit Sub End If
Set dic = CreateObject("Scripting.Dictionary")
For j = 1 To Target.Columns.Count dic(j) = "" Next
For j = 1 To Target.Columns.Count If Len(Target.Cells(1, j).Value) > 0 Then dic(Target.Cells(1, j).Value) = Application.Transpose(Target.Columns(j).Value) Else x = x + 1 dic(x) = Application.Transpose(Target.Columns(j).Value) End If Next
Target.Value = Application.Transpose(dic.items)
End Sub
iƒÀj 2015/01/15(–Ø) 09:21
Œ‹‹Çʼn‚̃R[ƒh‚Å‚¢‚¢‚ñ‚¶‚á‚È‚¢‚ÌH
Sub test() Dim x x = Split(InputBox("‘Š‘Ηñ‡‚Ì“ü—Í" & vbLf & "—á: 3,2,1,4,5", , "3,1,2,4,5,6,7,8,9,10"), ",") With Range("c4:l8") If UBound(x) <> .Columns.Count - 1 Then MsgBox "—ñ”‚Æ“ü—Í’l‚ª‡‚¢‚Ü‚¹‚ñ" Else .Value = Application.Index(.Value, Evaluate("row(1:" & .Rows.Count & ")"), x) End If End With End Sub iseiyaj 2015/01/15(–Ø) 09:51
[ ˆê——(ÅVXV‡) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.