{"categories":["Excel","VBA","\u4f5c\u3063\u3066\u307f\u305f"],"type":"rich","version":"1.0","provider_url":"https://hatena.blog","height":"190","title":"\u9078\u629e\u3057\u305f\u9805\u76ee\u4ee5\u5916\u306e\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u6d88\u3057\u3066\u307f\u308b","provider_name":"Hatena Blog","url":"https://infoment.hatenablog.com/entry/2018/12/21/224329","description":"\u6628\u65e5\u306f\u3001\u30b7\u30fc\u30c8\u4e0a\u306b\u3042\u308b\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u4e00\u89a7\u3092\u3001\u30e6\u30fc\u30b6\u30fc\u30d5\u30a9\u30fc\u30e0\u306e\u30ea\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306b\u8868\u793a\u3057\u3066\u307f\u305f\u3002 infoment.hatenablog.com \u4eca\u65e5\u306f\u3001\u9078\u629e\u3057\u305f\u9805\u76ee\u4ee5\u5916\u306e\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u306e\u524a\u9664\u306b\u6311\u6226\u3059\u308b\u3002 \u6628\u65e5\u306f\u3001\u30b7\u30fc\u30c8\u5185\u306b\u3042\u308b\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u306e\u300c\u6761\u4ef6\u5f0f\u300d\u3092\u62bd\u51fa\u3057\u3066\u3001\u30ea\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306b\u8868\u793a\u3057\u305f\u3002 \u30ea\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306e\u9805\u76ee\u306f\u3001\uff10\u756a\u304b\u3089\u59cb\u307e\u3063\u3066\u3044\u308b\u3002\u5f93\u3063\u3066\u3001\u8868\u306b\u3059\u308b\u3068\u3053\u3046\u306a\u308b\u3002 Listbox\u306en\u756a\u76ee \u6761\u4ef6\u5f0f 0 =MONTH($Q$1)<>MONTH(Q3) 1 =WEEKDAY(Q3)=1 2 =WEEKDAY(Q3)=7 3 =MONTH($A$1)<>MONTH(A3) 4 =MONTH($I$1)<>MO\u2026","author_url":"https://blog.hatena.ne.jp/Infoment/","author_name":"Infoment","width":"100%","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/I/Infoment/20181221/20181221220803.png","blog_url":"https://infoment.hatenablog.com/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Finfoment.hatenablog.com%2Fentry%2F2018%2F12%2F21%2F224329\" title=\"\u9078\u629e\u3057\u305f\u9805\u76ee\u4ee5\u5916\u306e\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f\u3092\u6d88\u3057\u3066\u307f\u308b - Infoment\u306e\u30d6\u30ed\u30b0 \uff5eExcel VBA\u596e\u95d8\u8a18\uff5e\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2018-12-21 22:43:29","blog_title":"Infoment\u306e\u30d6\u30ed\u30b0 \uff5eExcel VBA\u596e\u95d8\u8a18\uff5e"}