{"id":10724,"date":"2018-08-16T22:59:59","date_gmt":"2018-08-16T13:59:59","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=10724"},"modified":"2018-08-16T22:59:59","modified_gmt":"2018-08-16T13:59:59","slug":"%e9%81%b8%e6%8a%9e%e3%81%97%e3%81%a6%e3%81%84%e3%82%8b%e8%a1%8c%e3%81%ae%e9%ab%98%e3%81%95%e3%82%92%e5%a2%97%e3%82%84%e3%81%99excel%e3%83%9e%e3%82%af%e3%83%ad","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=10724","title":{"rendered":"\u9078\u629e\u3057\u3066\u3044\u308b\u884c\u306e\u9ad8\u3055\u3092\u5897\u3084\u3059Excel\u30de\u30af\u30ed"},"content":{"rendered":"<p>Excel\u306e\u8868\u3092\u5370\u5237\u3057\u3088\u3046\u3068\u3057\u305f\u3068\u304d\u3001\u30d3\u30df\u30e7\u30fc\u306b\u6587\u5b57\u304c\u5207\u308c\u3066\u3044\u3066\u30a4\u30e9\u30c3\u3068\u3059\u308b\u3053\u3068\u304c\u3088\u304f\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u305d\u3093\u306a\u3068\u304d\u306f\u7e2e\u5c0f\u3057\u3066\u5168\u4f53\u3092\u8868\u793a\u3057\u305f\u308a\u884c\u3084\u5e45\u3092\u8abf\u6574\u3057\u305f\u308a\u3057\u3066\u4f55\u3068\u304b\u3059\u308b\u306e\u3067\u3059\u304c\u3001\u8abf\u6574\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u30bb\u30eb\u304c\u8907\u6570\u3042\u308b\u3068\u3001\u4f5c\u696d\u3092\u4f55\u56de\u3082\u884c\u308f\u306a\u304f\u3066\u306f\u306a\u3089\u305a\u3001\u305d\u308c\u306f\u305d\u308c\u3067\u30a4\u30e9\u30c3\u3068\u3057\u307e\u3059\u3002<\/p>\n<p>\u305d\u3053\u3067\u3001\u30a4\u30e9\u30a4\u30e9\u89e3\u6d88\u306e\u305f\u3081\u306b\u7c21\u5358\u306a\u30de\u30af\u30ed\u3092\u66f8\u3044\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Public Sub IncrRowHeight()\r\n'\u9078\u629e\u884c\u306e\u9ad8\u3055\u3092\u5897\u3084\u3059\r\n  If LCase(TypeName(Selection)) &lt;&gt; &quot;range&quot; Then Exit Sub\r\n  On Error Resume Next\r\n  Selection.RowHeight = Selection.RowHeight + 5\r\nEnd Sub<\/pre>\n<p>\u9078\u629e\u3057\u3066\u3044\u308b\u884c\u306e\u9ad8\u3055\u3092\u3061\u3087\u3063\u3068\u305a\u3064\u5897\u3084\u3059\u3060\u3051\u306e\u30de\u30af\u30ed\u3067\u3059\u3002<br \/>\n\u3053\u306e\u30de\u30af\u30ed\u3092<a href=\"https:\/\/allabout.co.jp\/gm\/gc\/297809\/\" title=\"\u500b\u4eba\u7528\u30de\u30af\u30ed\u30d6\u30c3\u30af\u306e\u4f5c\u6210\u65b9\u6cd5\u3068\u4f7f\u3044\u65b9 [Excel VBA\u306e\u4f7f\u3044\u65b9] All About\" target=\"_blank\">\u500b\u4eba\u7528\u30de\u30af\u30ed\u30d6\u30c3\u30af<\/a>\u306b\u66f8\u3044\u3066\u3001\u30af\u30a4\u30c3\u30af \u30a2\u30af\u30bb\u30b9 \u30c4\u30fc\u30eb \u30d0\u30fc\u306b\u3067\u3082\u767b\u9332\u3057\u3066\u304a\u3051\u3070\u3001\u30ad\u30fc\u4e00\u767a\u3067\u547c\u3073\u51fa\u305b\u308b\u306e\u3067\u4fbf\u5229\u3067\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_VBA_IncrRowHeight_01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_VBA_IncrRowHeight_01.jpg\" alt=\"\" width=\"936\" height=\"678\" class=\"alignnone size-full wp-image-10725\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_VBA_IncrRowHeight_01.jpg 936w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_VBA_IncrRowHeight_01-300x217.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_VBA_IncrRowHeight_01-768x556.jpg 768w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_VBA_IncrRowHeight_02.gif\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/Excel_VBA_IncrRowHeight_02.gif\" alt=\"\" width=\"721\" height=\"475\" class=\"alignnone size-full wp-image-10726\" \/><\/a><\/p>\n<p>\u3064\u3044\u3067\u306b\u3001\u884c\u306e\u9ad8\u3055\u3092\u3061\u3087\u3063\u3068\u305a\u3064\u6e1b\u3089\u3059\u30de\u30af\u30ed\u3001\u5e45\u306e\u5897\u6e1b\u3092\u884c\u3046\u30de\u30af\u30ed\u3082\u8f09\u305b\u3066\u304a\u304d\u307e\u3059\u3002\u5897\u6e1b\u3059\u308b\u5024\u306f\u304a\u597d\u307f\u3067\u8abf\u6574\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Public Sub DecrRowHeight()\r\n'\u9078\u629e\u884c\u306e\u9ad8\u3055\u3092\u6e1b\u3089\u3059\r\n  If LCase(TypeName(Selection)) &lt;&gt; &quot;range&quot; Then Exit Sub\r\n  On Error Resume Next\r\n  Selection.RowHeight = Selection.RowHeight - 5\r\nEnd Sub\r\n\r\nPublic Sub IncrColumnWidth()\r\n'\u9078\u629e\u5217\u306e\u5e45\u3092\u5897\u3084\u3059\r\n  If LCase(TypeName(Selection)) &lt;&gt; &quot;range&quot; Then Exit Sub\r\n  On Error Resume Next\r\n  Selection.ColumnWidth = Selection.ColumnWidth + 1\r\nEnd Sub\r\n\r\nPublic Sub DecrColumnWidth()\r\n'\u9078\u629e\u5217\u306e\u5e45\u3092\u6e1b\u3089\u3059\r\n  If LCase(TypeName(Selection)) &lt;&gt; &quot;range&quot; Then Exit Sub\r\n  On Error Resume Next\r\n  Selection.ColumnWidth = Selection.ColumnWidth - 1\r\nEnd Sub<\/pre>\n<p>\u305d\u3093\u306a\u308f\u3051\u3067\u3001\u79c1\u306b\u3057\u3066\u306f\u73cd\u3057\u304f\u3001\u8aac\u660e\u304c\u8981\u3089\u306a\u3044\u304f\u3089\u3044\u30b7\u30f3\u30d7\u30eb\u306a\u30de\u30af\u30ed\u3092\u66f8\u3044\u3066\u307f\u307e\u3057\u305f\u3002\u300e<a href=\"https:\/\/tech.nikkeibp.co.jp\/it\/pc\/article\/knowhow\/20110619\/1032453\/\" title=\"\u300c\u3061\u3087\u3063\u3068\u3057\u305f\u3053\u3068\u306e\u81ea\u52d5\u5316\u300d\u3067\u3001\u4ed5\u4e8b\u306f30\u5206\u65e9\u304f\u306a\u308b | \u65e5\u7d4c xTECH\uff08\u30af\u30ed\u30b9\u30c6\u30c3\u30af\uff09\" target=\"_blank\">\u3061\u3087\u3063\u3068\u3057\u305f\u3053\u3068\u306e\u81ea\u52d5\u5316<\/a>\u300f\u3063\u3066\u5927\u4e8b\u3067\u3059\u3088\u306d\uff01<\/p>\n<div id=\"single_banner_area2\" class=\"clearfix one_banner\">\n<div class=\"single_banner single_banner_left\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- \u8a18\u4e8b\u4e2d(\u30c7\u30a3\u30b9\u30d7\u30ec\u30a4\u5e83\u544a\u30e6\u30cb\u30c3\u30c8) -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-7306936664602087\"\r\n     data-ad-slot=\"5429724765\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<div class=\"single_banner single_banner_right\">\n<a href=\"\" target=\"_blank\"><img decoding=\"async\" src=\"\" alt=\"\" title=\"\" \/><\/a>\n<\/div>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"Excel\u306e\u8868\u3092\u5370\u5237\u3057\u3088\u3046\u3068\u3057\u305f\u3068\u304d\u3001\u30d3\u30df\u30e7\u30fc\u306b\u6587\u5b57\u304c\u5207\u308c\u3066\u3044\u3066\u30a4\u30e9\u30c3\u3068\u3059\u308b\u3053\u3068\u304c\u3088\u304f\u3042\u308a\u307e\u3059\u3002 \u305d\u3093\u306a\u3068\u304d\u306f\u7e2e\u5c0f\u3057\u3066\u5168\u4f53\u3092\u8868\u793a\u3057\u305f\u308a\u884c\u3084\u5e45\u3092\u8abf\u6574\u3057\u305f\u308a\u3057\u3066\u4f55\u3068\u304b\u3059\u308b\u306e\u3067\u3059\u304c\u3001\u8abf\u6574\u3057\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u30bb\u30eb\u304c\u8907\u6570\u3042\u308b\u3068\u3001\u4f5c\u696d\u3092 [&hellip;]","protected":false},"author":1,"featured_media":7112,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"[\u9078\u629e\u3057\u3066\u3044\u308b\u884c\u306e\u9ad8\u3055\u3092\u5897\u3084\u3059Excel\u30de\u30af\u30ed]","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4,48],"tags":[],"class_list":["post-10724","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","category-excel-office"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-ExcelVBA.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-2MY","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/10724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10724"}],"version-history":[{"count":1,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/10724\/revisions"}],"predecessor-version":[{"id":10727,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/10724\/revisions\/10727"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7112"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}