{"id":3131,"date":"2022-01-07T09:00:31","date_gmt":"2022-01-07T00:00:31","guid":{"rendered":"https:\/\/www.bold.ne.jp\/engineer-club\/?p=3131"},"modified":"2025-11-19T10:04:34","modified_gmt":"2025-11-19T01:04:34","slug":"vba-uboundk","status":"publish","type":"post","link":"https:\/\/www.bold.ne.jp\/engineer-club\/vba-uboundk","title":{"rendered":"VBA\u306eUBound\u95a2\u6570\u3068\u306f\uff1f\u57fa\u672c\u7684\u306a\u69cb\u6587\u3084\u4f7f\u3044\u65b9\u3092\u89e3\u8aac"},"content":{"rendered":"<p>\u30c6\u30fc\u30d6\u30eb\u3084\u30a8\u30af\u30bb\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u914d\u5217\u306b\u683c\u7d0d\u3057\u3066\u3001\u914d\u5217\u306e\u8981\u7d20\u6570\u3060\u3051\u7e70\u308a\u8fd4\u3057\u51e6\u7406\u3092\u3057\u305f\u3044\u3068\u601d\u3063\u305f\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u304b\u3002<\/p>\n<p>UBound\u95a2\u6570\u3001<span>LBound<\/span>\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3068\u3001\u914d\u5217\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff08\u8981\u7d20\u6570\uff09\u306e\u6700\u5927\u5024\u3001\u6700\u5c0f\u5024\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3053\u3053\u3067\u306f\u3001<span>UBound<\/span>\u95a2\u6570\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">\u76ee\u6b21<\/p><ul class=\"toc_list\"><li><a href=\"#VBAUBound\">\uff11\uff0eVBA\u306eUBound\u95a2\u6570\u306b\u3064\u3044\u3066<\/a><ul><li><a href=\"#-UBound\">\uff11-\uff11\uff0eUBound\u95a2\u6570\u3068\u306f<\/a><\/li><li><a href=\"#-UBound-2\">\uff11-\uff12\uff0eUBound\u95a2\u6570\u306e\u69cb\u6587<\/a><\/li><\/ul><\/li><li><a href=\"#VBAUBound-2\">\uff12\uff0e\u3010VBA\u3011UBound\u95a2\u6570\u306e\u4f7f\u7528\u4f8b<\/a><ul><li><a href=\"#i\">\uff12-\uff11\uff0e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b<\/a><\/li><li><a href=\"#i-2\">\uff12-\uff12\uff0e\u4ed6\u306e\u95a2\u6570\u3082\u4f7f\u3063\u305f\u4f7f\u7528\u4f8b<\/a><\/li><\/ul><\/li><li><a href=\"#VBAUBound-3\">\uff13\uff0eVBA\u306eUBound\u95a2\u6570\u3067\u6ce8\u610f\u3059\u3079\u304d\u3053\u3068<\/a><\/li><li><a href=\"#i-3\">\uff14\uff0e\u6700\u5f8c\u306b<\/a><\/li><\/ul><\/div>\n<h2><span id=\"VBAUBound\">\uff11\uff0eVBA\u306e<span>UBound<\/span>\u95a2\u6570\u306b\u3064\u3044\u3066<\/span><\/h2>\n<h3><span id=\"-UBound\"><span>\uff11-\uff11\uff0eUBound<\/span>\u95a2\u6570\u3068\u306f<\/span><\/h3>\n<p><span>UBound<\/span>\u95a2\u6570\u3068\u306f\u3001<strong><\/strong><span class=\"f-marker-p\"><strong>\u914d\u5217\u306e\u6307\u5b9a\u3055\u308c\u305f\u6b21\u5143\u3067\u4f7f\u7528\u53ef\u80fd\u306a\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u6700\u5927\u5024\u3092\u53d6\u5f97\u3059\u308b\u95a2\u6570<\/strong><\/span>\u3067\u3059\u3002\u4e3b\u306b\u3001\u914d\u5217\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u6570\u3060\u3051\u7e70\u308a\u8fd4\u3057\u51e6\u7406\u3092\u884c\u3046\u969b\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002\u6700\u5c0f\u5024\u306e\u5834\u5408\u306f\u300c<span>Lbpound<\/span>\u300d\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u203b\u300c\u914d\u5217\u306e\u6700\u5927\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306b\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u5024\u300d\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n<h3><span id=\"-UBound-2\">\uff11-\uff12\uff0e<span>UBound<\/span>\u95a2\u6570\u306e\u69cb\u6587<\/span><\/h3>\n<div class=\"attention a-1\">\n<p>UBound<span>(<\/span>\u914d\u5217\u306e\u540d\u524d, \u5bfe\u8c61\u306e\u6b21\u5143<span>)<br \/>\n<\/span>\u623b\u308a\u5024\u306fLong\u5f62\u5f0f<\/p>\n<\/div>\n<p>\u300c\u5bfe\u8c61\u306e\u6b21\u5143\u300d\u3068\u306f\u3001\u591a\u6b21\u5143\u914d\u5217\u306e\u5834\u5408\u306b\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<h2><span id=\"VBAUBound-2\">\uff12\uff0e\u3010VBA\u3011<span>UBound<\/span>\u95a2\u6570\u306e\u4f7f\u7528\u4f8b<\/span><\/h2>\n<h3><span id=\"i\">\uff12-\uff11\uff0e\u57fa\u672c\u7684\u306a\u4f7f\u7528\u4f8b<\/span><\/h3>\n<p><span>Ubound<\/span>\u95a2\u6570\u306e\u5f15\u6570\u4e00\u3064\u306e\u4f8b<\/p>\n<pre class=\"prettyprint lang:default decode:true\">Sub Sample1()\r\n    '\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5024\u304c7\u306e\u914d\u5217\r\n    Dim arr(7) As Integer\r\n\r\n    MsgBox \"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5024\u306f \" &amp; UBound(arr) &amp; \" \u3067\u3059\"\r\n\r\nEnd Sub<\/pre>\n<p><span class=\"f-marker-w\">\u5b9f\u884c\u7d50\u679c\uff1a\u914d\u5217\u3067\u5ba3\u8a00\u3057\u305f\u300c<span>7<\/span>\u300d\u304c\u53d6\u5f97\u3055\u308c\u3066\u3044\u307e\u3059<\/span><\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c1.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c1.png\" alt=\"\" width=\"151\" height=\"128\" class=\"alignnone size-full wp-image-3132\" \/><\/a><\/p>\n<p>Ubound\u95a2\u6570\u306e\u5f15\u6570\u4e8c\u3064\u306e\u5834\u5408<\/p>\n<pre class=\"prettyprint lang:default decode:true\">Sub Sample2()\r\n    '3\u6b21\u5143\u914d\u5217\u3067\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u300c7, 5, 10\u300d\r\n    Dim arr(7, 5, 10) As Integer\r\n\r\n    \r\n    MsgBox \"\u30a4\u30f3\u30c7\u30c3\u30af\u30b91\u306e\u5024\u306f \" &amp; UBound(arr, 1) &amp; \" \u3067\u3059\"\r\n    MsgBox \"\u30a4\u30f3\u30c7\u30c3\u30af\u30b92\u306e\u5024\u306f \" &amp; UBound(arr, 2) &amp; \" \u3067\u3059\"\r\n    MsgBox \"\u30a4\u30f3\u30c7\u30c3\u30af\u30b93\u306e\u5024\u306f \" &amp; UBound(arr, 3) &amp; \" \u3067\u3059\"\r\n    \r\nEnd Sub\r\n<\/pre>\n<p><span class=\"f-marker-w\">\u5b9f\u884c\u7d50\u679c\uff1a\u914d\u5217\u3067\u5ba3\u8a00\u3057\u305f\u300c<span>7<\/span>\u300d\u3001\u300c<span>5<\/span>\u300d\u3001\u300c<span>10<\/span>\u300d\u304c\u53d6\u5f97\u3055\u308c\u3066\u3044\u307e\u3059<\/span><\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c4.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c4.png\" alt=\"\" width=\"163\" height=\"128\" class=\"size-full wp-image-3135 alignleft\" \/><\/a><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c.png\" alt=\"\" width=\"157\" height=\"128\" class=\"size-full wp-image-3134 alignleft\" \/><\/a><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c2.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c2.png\" alt=\"\" width=\"157\" height=\"128\" class=\"size-full wp-image-3133 alignleft\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3><span id=\"i-2\">\uff12-\uff12\uff0e\u4ed6\u306e\u95a2\u6570\u3082\u4f7f\u3063\u305f\u4f7f\u7528\u4f8b<\/span><\/h3>\n<p>\u2605<span>Lbound<\/span>\u3092\u4f7f\u3063\u305f\u914d\u5217\u306e\u6700\u5c0f\u6700\u5927\u5024\u306e\u53d6\u5f97<\/p>\n<pre class=\"prettyprint lang:default decode:true\">Sub Sample3()\r\n    Dim arr(3) As Integer\r\n    Dim i As Integer\r\n\r\n    For i = LBound(arr) To UBound(arr)\r\n        MsgBox i + 1 &amp; \"\u56de\u76ee\u3067\u3059\"\r\n    Next\r\n\r\nEnd Sub\r\n<\/pre>\n<p><span class=\"f-marker-w\">\u5b9f\u884c\u7d50\u679c\uff1a\u914d\u5217\u3067\u5ba3\u8a00\u3057\u305f\u5024<span>+1<\/span>\u56de\u30eb\u30fc\u30d7\u3057\u3066\u3044\u307e\u3059<\/span><\/p>\n<p>\u203b\u914d\u5217\u306f\u3001<span>0<\/span>\u756a\u76ee\u304b\u3089\u306f\u3058\u307e\u308a\u307e\u3059<\/p>\n<p>LBound\u3067\u53d6\u5f97\u3057\u305f\u5024\uff1a<span>0<\/span><\/p>\n<p>UBounbd\u3067\u53d6\u5f97\u3057\u305f\u5024\uff1a<span>3<\/span><\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c5.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c5.png\" alt=\"\" width=\"127\" height=\"128\" class=\"size-full wp-image-3136 alignleft\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c6-1.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c6-1.png\" alt=\"\" width=\"127\" height=\"128\" class=\"size-full wp-image-3138 alignleft\" \/><\/a><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c7-1.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c7-1.png\" alt=\"\" width=\"127\" height=\"128\" class=\"size-full wp-image-3140 alignleft\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c8-1.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c8-1.png\" alt=\"\" width=\"127\" height=\"128\" class=\"size-full wp-image-3142 alignleft\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span id=\"VBAUBound-3\">\uff13\uff0eVBA\u306e<span>UBound<\/span>\u95a2\u6570\u3067\u6ce8\u610f\u3059\u3079\u304d\u3053\u3068<\/span><\/h2>\n<p>\u4e0b\u8a18\u306e\u3088\u3046\u306b\u3001\u9014\u4e2d\u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u6570\u304c\u5909\u66f4\u3055\u308c\u308b\u5834\u5408\u3001\u5b9f\u969b\u306b\u5024\u3092\u4f7f\u7528\u3059\u308b\u76f4\u524d\u3067\u53d6\u5f97\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"prettyprint lang:default decode:true\">Sub Sample4()\r\n    Dim arr() As Variant\r\n\r\n    '\u914d\u5217arr\u3092\u30a4\u30f3\u30c7\u30c3\u30af\u30b93\u3064\u3067\u521d\u671f\u5316\r\n    arr = Array(1, 2, 3)\r\n\r\n    MsgBox \"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5024\u306f \" &amp; UBound(arr) + 1 &amp; \" \u3067\u3059\"  \u2018\u203b1 \u521d\u671f\u5316\u3057\u305f3\u3092\u53d6\u5f97\r\n\r\n    '\u914d\u5217arr\u3092\u30a4\u30f3\u30c7\u30c3\u30af\u30b94\u3064\u3067\u521d\u671f\u5316\r\n    arr = Array(1, 2, 3, 4)\r\n\r\n    MsgBox \"\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u5024\u306f \" &amp; UBound(arr) + 1 &amp; \" \u3067\u3059\"  \u2018\u203b2 \u521d\u671f\u5316\u3057\u305f4\u3092\u53d6\u5f97\r\n\r\n\r\nEnd Sub\r\n<\/pre>\n<p><span class=\"f-marker-w\">\u5b9f\u884c\u7d50\u679c\uff1a<\/span><\/p>\n<p>\u203b<span>1<\/span>\u6642\u70b9\u3067\u306e\u5b9f\u884c\u7d50\u679c\uff1a<\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c9.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c9.png\" alt=\"\" width=\"151\" height=\"128\" class=\"alignnone size-full wp-image-3143\" \/><\/a><\/p>\n<p>\u203b<span>2<\/span>\u6642\u70b9\u3067\u306e\u5b9f\u884c\u7d50\u679c\uff1a<\/p>\n<p><a href=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c10.png\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/www.bold.ne.jp\/engineer-club\/wp-content\/uploads\/2022\/01\/\u7d50\u679c10.png\" alt=\"\" width=\"151\" height=\"128\" class=\"alignnone size-full wp-image-3144\" \/><\/a><\/p>\n<h2><span id=\"i-3\">\uff14\uff0e\u6700\u5f8c\u306b<\/span><\/h2>\n<p>UBound\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u306f\u3001\u914d\u5217\u306e\u69cb\u9020\u3084\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u6570\u306e\u56fa\u5b9a\u5024\uff0f\u53ef\u5909\u5024\u306b\u6ce8\u610f\u3057\u3066\u3001\u4f7f\u3063\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30c6\u30fc\u30d6\u30eb\u3084\u30a8\u30af\u30bb\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u3092\u914d\u5217\u306b\u683c\u7d0d\u3057\u3066\u3001\u914d\u5217\u306e\u8981\u7d20\u6570\u3060\u3051\u7e70\u308a\u8fd4\u3057\u51e6\u7406\u3092\u3057\u305f\u3044\u3068\u601d\u3063\u305f\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u304b\u3002 UBound\u95a2\u6570\u3001LBound\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3068\u3001\u914d\u5217\u306e\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff08\u8981\u7d20\u6570\uff09\u306e\u6700\u5927\u5024\u3001\u6700\u5c0f\u5024\u3092\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":3146,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/3131"}],"collection":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/comments?post=3131"}],"version-history":[{"count":8,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/3131\/revisions"}],"predecessor-version":[{"id":6067,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/posts\/3131\/revisions\/6067"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/media\/3146"}],"wp:attachment":[{"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/media?parent=3131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bold.ne.jp\/engineer-club\/wp-json\/wp\/v2\/categories?post=3131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}