{"type":"rich","author_url":"https://blog.hatena.ne.jp/hiko-blog/","description":"Sub GroupAndCollapseColumns() ' C\u5217\u304b\u3089F\u5217\u307e\u3067\u3092\u30b0\u30eb\u30fc\u30d7\u5316 Columns(\"C:F\").Select Selection.Columns.Group ' \u30b0\u30eb\u30fc\u30d7\u3092\u9589\u3058\u305f\u72b6\u614b\u306b\u8a2d\u5b9a Columns(\"C:F\").EntireColumn.Hidden = TrueEnd Sub Sub GroupAndCollapseRows() ' 3\u884c\u76ee\u304b\u30896\u884c\u76ee\u307e\u3067\u3092\u30b0\u30eb\u30fc\u30d7\u5316 Rows(\"3:6\").Select Selection.Rows.Group ' \u30b0\u30eb\u30fc\u30d7\u3092\u9589\u3058\u305f\u72b6\u614b\u306b\u8a2d\u5b9a Rows(\"3:6\").EntireRow.Hidden = TrueEnd S\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhiko-blog.hatenadiary.com%2Fentry%2F2024%2F08%2F22%2F195711\" title=\"\u5217\u3068\u884c\u306e\u30b0\u30eb\u30fc\u30d7\u5316\u30fb\u30fb\u30fb\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9 - Hiko.Blog  Excel VBA\u6d3b\u7528\u8853\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","width":"100%","categories":["VBA"],"image_url":null,"height":"190","author_name":"hiko-blog","provider_url":"https://hatena.blog","blog_title":"Hiko.Blog  Excel VBA\u6d3b\u7528\u8853","published":"2024-08-22 19:57:11","url":"https://hiko-blog.hatenadiary.com/entry/2024/08/22/195711","title":"\u5217\u3068\u884c\u306e\u30b0\u30eb\u30fc\u30d7\u5316\u30fb\u30fb\u30fb\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9","blog_url":"https://hiko-blog.hatenadiary.com/","provider_name":"Hatena Blog","version":"1.0"}