[B! tips][excel] todogzmã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

todogzm id:todogzm

tipsã¨excelã«é–¢ã™ã‚‹todogzmã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

è¤‡æ•°ã‚·ãƒ¼ãƒˆå°åˆ·æ™‚ã®ãƒšãƒ¼ã‚¸è¨å®š:Excel(ã‚¨ã‚¯ã‚»ãƒ«)ã®ä½¿ã„æ–¹/å°åˆ·
è¤‡æ•°ã®ã‚·ãƒ¼ãƒˆã‚’ä¸€åº¦ã«å°åˆ·ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ãŸã¨ãã«ã€ã‚ˆãã„ãŸã ãè³ªå•ãŒã‚ã‚Šã¾ã™ã€‚ ã€Œãƒšãƒ¼ã‚¸è¨å®šã‚’ä¸€åº¦ã«è¡Œã†ã“ã¨ã¯ã§ããªã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿã€ ã€Œãƒšãƒ¼ã‚¸è¨å®šã¯å€‹ã€…ã®ã‚·ãƒ¼ãƒˆã§è¡Œã‚ãªã„ã¨ã„ã‘ãªã„ã®ã§ã™ã‹ï¼Ÿã€ ã¨ã„ã†ã”è³ªå•ã§ã™ã€‚ ä½œæ¥ã‚°ãƒ«ãƒ¼ãƒ—ã‚’è¨å®šã—ãŸçŠ¶æ…‹ã‹ã‚‰å°åˆ·ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’è¡Œã„ã€ï¼»è¨å®šï¼½ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦è¡¨ç¤ºã•ã‚Œã‚‹ã€ï¼»ãƒšãƒ¼ã‚¸è¨å®šï¼½ãƒ€ã‚¤ã‚¢ãƒã‚°ã§ãƒšãƒ¼ã‚¸è¨å®šæ“ä½œã‚’è¡Œã£ã¦ã‚‚ã€å…¨ã¦ã®ã‚·ãƒ¼ãƒˆã«å¯¾ã—ã¦ãƒšãƒ¼ã‚¸è¨å®šãŒè¡Œã‚ã‚Œãªã„ãŸã‚ã«ã„ãŸã ãã”è³ªå•ã§ã™ã€‚
todogzm 2010/11/30
excel

tips
ãƒªãƒ³ã‚¯
Excelã§ã®å½“è©²æœˆã®æœ€çµ‚æ—¥å–å¾—ã«ã¤ã„ã¦ - OKWAVE
Excel2000ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚ è³ªå•ãªã‚“ã§ã™ãŒã€å¹´æœˆã‚’æŒ‡å®šã—ã¦ãã®æœˆã®æœ€çµ‚æ—¥ã‚’å–å¾—ã™ã‚‹ã«ã¯ã©ã†ã™ã‚Œã°è‰¯ã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ä¾‹ãˆã°ã€2004å¹´2æœˆã®æœ€çµ‚æ—¥ã‚’å–å¾—ã™ã‚‹å ´åˆã€‚ ã‚»ãƒ«A1ã«ã€€2004 ã‚»ãƒ«A2ã«ã€€ã€€ 2ã€€ã‚’å…¥åŠ›ã—ã¦ ã‚»ãƒ«A3ã«ã€€ã€€29ã€€ã¨è¡¨ç¤ºã•ã›ãŸã„ã®ã§ã™ã€‚ ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚
todogzm 2010/10/19
excel

tips
ãƒªãƒ³ã‚¯
http://ohpa.net/modules/xlnote/content0151.html
todogzm 2010/10/19
excel

tips
ãƒªãƒ³ã‚¯
ãƒžã‚¯ãƒãŒãªã„ã®ã«é–‹ãã¨ãã«ãƒ€ã‚¤ã‚¢ãƒã‚°ãŒè¡¨ç¤ºã•ã‚Œã‚‹:ã‚¨ã‚¯ã‚»ãƒ«ãƒžã‚¯ãƒãƒ»Excel VBAã®ä½¿ã„æ–¹
ã“ã‚Œã¯ãƒžã‚¯ãƒã®å‰Šé™¤ã ã‘ã‚’è¡Œã„ã€ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®è§£æ”¾ï¼ˆå®Œå…¨ãªå‰Šé™¤ï¼‰ã‚’è¡Œã£ã¦ã„ãªã„ã¨ãã«èµ·ãã¾ã™ã€‚ ä»¥ä¸‹ã®æ‰‹é †ã§ã€è©²å½“ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®è§£æ”¾ã‚’è¡Œã£ã¦ãã ã•ã„ã€‚ â–¼æ“ä½œæ‰‹é †ã€€ï¼šãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®è§£æ”¾ ãƒ¡ãƒ‹ãƒ¥ãƒ¼ï¼»ãƒ„ãƒ¼ãƒ«ï¼½âˆ’ï¼»ãƒžã‚¯ãƒï¼½âˆ’ï¼»Visual Basic Editorï¼½ã‚’ã‚¯ãƒªãƒƒã‚¯ â†“ Visual Basic Editorã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©ã§ï¼»æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ï¼½ãƒ•ã‚©ãƒ«ãƒ€ã‚’é–‹ã â†“ ã€ŒModuleXã€ã¨ã„ã†ã‚ˆã†ãªåç§°ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒã‚ã‚Œã°å³ã‚¯ãƒªãƒƒã‚¯âˆ’ï¼»ModuleXã®è§£æ”¾ï¼½ã‚’ã‚¯ãƒªãƒƒã‚¯ ï¼ˆExcel 97ã®å ´åˆã¯ï¼»ModuleXã®å‰Šé™¤ï¼½ã¨è¡¨ç¤ºã•ã‚Œã¾ã™ï¼‰ â†“ ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹ã‹ã¨ã„ã†ç¢ºèªãƒ€ã‚¤ã‚¢ãƒã‚°ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ã§ã€Œã„ã„ãˆã€ã‚’ã‚¯ãƒªãƒƒã‚¯ â†“ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚¨ã‚¯ã‚¹ãƒ—ãƒãƒ¼ãƒ©ã«æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒãªããªã£ãŸã“ã¨ã‚’ç¢ºèª â†“ Visual Basic Editorã‚’çµ‚äº†ã—ã€Excelã‚’ä¸Šæ›¸ãä¿å˜
todogzm 2010/04/13
excel

tips

vba
ãƒªãƒ³ã‚¯
æ¡ä»¶ä»˜ãæ›¸å¼ã®ä½¿ã„æ–¹ï¼šExcelåŸºæœ¬è¬›åº§
ã‚¨ã‚¯ã‚»ãƒ«ã§ã¯æ¡ä»¶ã«ã‚ˆã£ã¦è‡ªå‹•çš„ã«ã‚»ãƒ«ã‚„ãƒ•ã‚©ãƒ³ãƒˆã®è‰²ã‚’å¤‰ãˆã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã‚¨ã‚¯ã‚»ãƒ«ã®é–¢æ•°ã§æ›¸å¼ã‚’å¤‰æ›´ã™ã‚‹ã“ã¨ã¯å‡ºæ¥ã¾ã›ã‚“ã®ã§ã€ã“ã®æ¡ä»¶ä»˜ãæ›¸å¼ã‚‚ã—ãã¯VBAã‚’ä½¿ã„ã¾ã™ã€‚ æ¡ä»¶ä»˜ãæ›¸å¼ã¨ã¯ï¼Ÿã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€ã€€Topã¸ ç‰¹å®šã®æ¡ä»¶ã«å½“ã¦ã¯ã¾ã‚‹ã‚»ãƒ«ã®æ›¸å¼ã‚’å¤‰æ›´ã—ã¾ã™ã€‚ è‡ªå‹•ã§æ›¸å¼ã‚’å¤‰æ›´ã™ã‚‹ã“ã¨ã¯é–¢æ•°ã§ã¯ã§ããªã„ã®ã§ã€ã“ã®æ¡ä»¶ä»˜ãæ›¸å¼ã‚’ä½¿ã†ã‹ãƒžã‚¯ãƒã‚’æ›¸ãã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ãƒã‚¤ãƒ³ãƒˆ æ¡ä»¶ä»˜ãæ›¸å¼ã‚’è¨å®šã™ã‚‹ã‚»ãƒ«ç¯„å›²ã‚’ã‚ã‚‰ã‹ã˜ã‚é¸æŠžã—ã¦ã‹ã‚‰ã€è¨å®šã‚’è¡Œã†ã¨é¸æŠžã—ãŸã‚»ãƒ«ç¯„å›²ã«1å›žã§è¨å®šãŒã§ãã¾ã™ã€‚ æ›¸å¼ã®ã‚³ãƒ”ãƒ¼/è²¼ã‚Šä»˜ã‘ãƒœã‚¿ãƒ³ã‚’ä½¿ã£ã¦ã€ä»–ã®ã‚»ãƒ«ã«ã‚‚æ¡ä»¶ä»˜ãæ›¸å¼ã®è¨å®šã‚’åŠ ãˆã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ ãŸã ã—ã€ã‚»ãƒ«ã®æ›¸å¼ã‚‚åŒæ™‚ã«ã‚³ãƒ”ãƒ¼ã•ã‚Œã¾ã™ã€‚ [ãƒ›ãƒ¼ãƒ ]ã‚¿ãƒ–ã®[æ›¸å¼ã®ã‚³ãƒ”ãƒ¼/è²¼ã‚Šä»˜ã‘]ã‚’ä½¿ã„ã¾ã™ã€‚ æ¡ä»¶ä»˜ãæ›¸å¼ã®ãƒ«ãƒ¼ãƒ«ã®ç®¡ç†ã§é©ç”¨å…ˆã‚’ä¿®æ£ã—ã¦ã€ã‚»ãƒ«ç¯„å›²ã‚’åºƒã’ãŸã‚Šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ä¸‹å›³ã¯B2:B4ã‚»ãƒ«ã®æ¡ä»¶ä»˜
todogzm 2008/03/26
excel

tips
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆ(ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆ)ã‹ã‚‰é¸æŠžå…¥åŠ›ã™ã‚‹ï¼“ã¤ã®æ–¹æ³•
ãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã‹ã‚‰é¸æŠžå…¥åŠ›ã™ã‚‹ å…¥åŠ›ã™ã¹ãé …ç›®ãŒäºˆã‚æ±ºã¾ã£ã¦ã„ã‚‹å ´åˆã¯ã€ãƒªã‚¹ãƒˆã‹ã‚‰é¸æŠžã—ã¦ã‚»ãƒ«ã«å…¥åŠ›ã™ã‚‹æ–¹æ³•ãŒä¾¿åˆ©ã§ã™ã€‚ ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã®è¨å®šï½žé¸æŠžè‚¢ã‚’é¸ã¶ã ã‘ ã‚¨ã‚¯ã‚»ãƒ«ãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã®å…¥åŠ›æ–¹æ³•3ãƒ‘ã‚¿ãƒ¼ãƒ³ ä»Šå›žã¯ã€ãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆï¼ˆãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆï¼‰ã®è¨å®šæ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ è¡¨ã‚’ä½œæˆã—ã¦ã„ã¦ã€åŒã˜èªžå¥ã‚’ä½•åº¦ã‚‚å…¥åŠ›ã™ã‚‹ã®ã¯é¢å€’ã§ã™ãã€‚ Excelã®å…¥åŠ›è¦å‰‡ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿å…¥åŠ›ã‚’ãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã®å€¤ã«åˆ¶é™ã™ã‚‹æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ã€‚ãƒ—ãƒ«ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã¯åŒã˜èªžå¥ã‚’ä½•åº¦ã‚‚å…¥åŠ›ã™ã‚‹ä»£ã‚ã‚Šã«é¸æŠžè‚¢ã‹ã‚‰é¸ã¹ã‚‹ä¾¿åˆ©ãªæ©Ÿèƒ½ã§ã™ã€‚
todogzm 2007/12/19
excel

tips
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ãƒªã‚¹ãƒˆã‹ã‚‰é¸æŠžå…¥åŠ›ã™ã‚‹ï¼“ã¤ã®æ–¹æ³•
ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã‹ã‚‰å…¥åŠ›ã™ã‚‹ ä»Šåº¦ã¯ã€åˆ¥ã‚·ãƒ¼ãƒˆã«ãƒžã‚¹ã‚¿è¡¨ã‚’ä½œæˆã—ã¦ãƒªã‚¹ãƒˆé¸æŠžã§ãã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã‹ã‚‰å…¥åŠ›ã™ã‚‹ï¼“ã¤ã®æ–¹æ³•ã®æœ€å¾Œã§ã™ã€‚ ãƒªã‚¹ãƒˆã‚’åˆ¥ã‚·ãƒ¼ãƒˆã«ä½œæˆã—ã¦ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³å…¥åŠ›ã™ã‚‹ ãƒªã‚¹ãƒˆé¸æŠžã¯ä¾¿åˆ©ã§ã™ãŒã€ãƒªã‚¹ãƒˆãŒãƒ¡ã‚¤ãƒ³ã®è¡¨ã¨åŒã˜ã‚·ãƒ¼ãƒˆã«ã‚ã‚‹ã®ã¯ã€ãªã‚“ã¨ãªãã€è¦‹æ „ãˆãŒæ‚ªã„ã¨æ€ã†å ´åˆã‚‚ã‚ã‚Šã¾ã™ãã€‚ ãã‚“ãªæ™‚ã¯ã€ãƒªã‚¹ãƒˆã‚’åˆ¥ã®è¡¨ã«ä½œæˆã—ã¦ã—ã¾ã†ã¨ã€ã‚¹ãƒƒã‚ãƒªã—ã¦è¦‹æ „ãˆãŒè‰¯ããªã‚Šã¾ã™ã€‚ ãã‚Œã«åˆ¥ã‚·ãƒ¼ãƒˆã®æ–¹ãŒã€ãƒªã‚¹ãƒˆã‚’èª¤ã£ã¦å¤‰æ›´ã—ã¦ã—ã¾ã†ã¨ã„ã†ã‚ˆã†ãªãƒˆãƒ©ãƒ–ãƒ«ã‚‚å°‘ãªããªã‚Šã¾ã™ã€‚ ã¾ãŸã€ãƒªã‚¹ãƒˆã®æŒ‡å®šã‚’ç°¡å˜ã«ã™ã‚‹ãŸã‚ã«ã€ãƒžã‚¹ã‚¿ã«åå‰ã‚’å®šç¾©ã—ã¦ã„ã¾ã™ã€‚
todogzm 2007/12/19
excel

tips
ãƒªãƒ³ã‚¯
Excelã§å–¶æ¥æ—¥ã®è¨ˆç®—ã‚’ã™ã‚‹
è§£èª¬ å¤§å°å•ã‚ãšã€æ³•äººã‚„å›£ä½“ã§ã¯å–¶æ¥æ—¥ã¨ã„ã†è€ƒãˆæ–¹ãŒã‚ã‚‹ã ã‚ã†ã€‚ãã—ã¦ã€æ¥å‹™ä¸Šã®å‡¦ç†ã«ãŠã„ã¦å–¶æ¥æ—¥ãƒ™ãƒ¼ã‚¹ã§æ—¥æ•°ã‚’è¨ˆç®—ã™ã‚‹å¿…è¦æ€§ã¯å°‘ãªã‹ã‚‰ãšå˜åœ¨ã™ã‚‹ã¯ãšã§ã‚ã‚‹ã€‚åœŸæ—¥ã‚„å›½ã®å®šã‚ã‚‹ç¥æ—¥ã«é™ã‚‰ãšã€å‰µç«‹è¨˜å¿µæ—¥ã‚„å¤å£ä¼‘æ—¥ãªã©ç‹¬è‡ªã«å®šã‚ã‚‰ã‚ŒãŸä¼‘æ¥æ—¥ã‚‚ã‚ã‚‹ãŸã‚ã€ä¸€è¦‹å–¶æ¥æ—¥ãƒ™ãƒ¼ã‚¹ã§ã®æ—¥ä»˜è¨ˆç®—ã¯éžå¸¸ã«é›£è§£ã«æ€ã‚ã‚Œã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã€‚ ã ãŒExcelã«ã¯ã€WORKDAYé–¢æ•°ã¨NETWORKDAYSé–¢æ•°ã¨ã„ã†éžå¸¸ã«ä¾¿åˆ©ãªé–¢æ•°ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã€‚ã“ã‚Œã‚‰ã¯ã€é€±æœ«ã‚„ä¼‘æ—¥ãªã©ã‚’é™¤å¤–ã—ã¦æ—¥æ•°ï¼ˆç¨¼åƒæ—¥ï¼‰ã‚’è¨ˆç®—ã™ã‚‹ãŸã‚ã®é–¢æ•°ã§ã‚ã‚‹ã€‚ã“ã‚Œã‚‰ã®é–¢æ•°ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€å€‹ã€…ã®å–¶æ¥æ—¥äº‹æƒ…ã«åˆã‚ã›ãŸæ—¥ä»˜è¨ˆç®—ã‚’ç°¡å˜ã«è¡Œãˆã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ æœ¬ç¨¿ã§ã¯ã€ä¾‹ã¨ã—ã¦è¦‹ç©æ›¸ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆä½œæˆã‚’é€šã˜ã¦WORKDAYé–¢æ•°ã®ä½¿ç”¨æ–¹æ³•ã‚’ç´¹ä»‹ã—ã€ãã—ã¦å‡ºè·æ‰€è¦æ—¥æ•°ã‚’åˆ†æžã™ã‚‹è¡¨ã®ä½œæˆã‚’é€šã˜ã¦NETWORKDAYSé–¢æ•°ã®ä½¿ç”¨æ–¹æ³•ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ æ“ä½œæ–¹æ³• â—æ‰‹é †1â€•Excelã®ã‚¢ãƒ‰ã‚¤
todogzm 2007/04/24
tips

excel

ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†
ãƒªãƒ³ã‚¯
1