{"id":3956,"date":"2015-10-14T11:35:36","date_gmt":"2015-10-14T02:35:36","guid":{"rendered":"http:\/\/excelwork.info\/excel\/?p=3956"},"modified":"2015-10-14T11:35:36","modified_gmt":"2015-10-14T02:35:36","slug":"headerfooter00","status":"publish","type":"post","link":"https:\/\/excelwork.info\/excel\/headerfooter00\/","title":{"rendered":"\u5370\u5237\u8a2d\u5b9a\uff08\u30d8\u30c3\u30c0\u30fc\uff0f\u30d5\u30c3\u30bf\u30fc\uff09\u66f8\u5f0f\u30b3\u30fc\u30c9\u30fbVBA\u30b3\u30fc\u30c9"},"content":{"rendered":"<h2>\u5370\u5237\u8a2d\u5b9a\uff08\u30d8\u30c3\u30c0\u30fc\uff0f\u30d5\u30c3\u30bf\u30fc\uff09\u66f8\u5f0f\u30b3\u30fc\u30c9\u30fbVBA\u30b3\u30fc\u30c9<\/h2>\n<div class=\"m30-l\">\n<p>\u30d8\u30c3\u30c0\u30fc\u304a\u3088\u3073\u30d5\u30c3\u30bf\u30fc\uff08LeftHeader \u30d7\u30ed\u30d1\u30c6\u30a3\u3001CenterHeader \u30d7\u30ed\u30d1\u30c6\u30a3\u3001RightHeader \u30d7\u30ed\u30d1\u30c6\u30a3\u3001LeftFooter \u30d7\u30ed\u30d1\u30c6\u30a3\u3001CenterFooter \u30d7\u30ed\u30d1\u30c6\u30a3\u3001RightFooter \u30d7\u30ed\u30d1\u30c6\u30a3\uff09\u306b\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u3001\u66f8\u5f0f\u30b3\u30fc\u30c9\u30fbVBA\u30b3\u30fc\u30c9\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<h3><strong>\u30d8\u30c3\u30c0\u30fc\u3068\u30d5\u30c3\u30bf\u30fc\u306b\u6307\u5b9a\u3067\u304d\u308b\u66f8\u5f0f\u30b3\u30fc\u30c9<\/strong><\/h3>\n<table>\n<tr>\n<td align = \"center\" width=\"200\" bgcolor=\"#fffccc\"><strong>\u66f8\u5f0f\u30b3\u30fc\u30c9<\/strong><\/td>\n<td align = \"center\" width=\"450\" bgcolor=\"#fffccc\"><strong>\u8aac\u660e<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;L<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u3092\u5de6\u8a70\u3081\u306b\u914d\u7f6e<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;C<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u3092\u4e2d\u592e\u63c3\u3048\u306b\u914d\u7f6e<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;R<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u3092\u53f3\u8a70\u3081\u306b\u914d\u7f6e<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;E<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u306b\u4e8c\u91cd\u4e0b\u7dda\u3092\u8a2d\u5b9a<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;X<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u3092\u4e0a\u4ed8\u304d\u6587\u5b57\u306b\u8a2d\u5b9a<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;Y<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u3092\u4e0b\u4ed8\u304d\u6587\u5b57\u306b\u8a2d\u5b9a<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;B<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u3092\u592a\u5b57\u306b\u8a2d\u5b9a<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;I<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u3092\u659c\u4f53\u306b\u8a2d\u5b9a<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;U<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u306b\u4e0b\u7dda\u3092\u8a2d\u5b9a<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;S<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u306b\u53d6\u308a\u6d88\u3057\u7dda\u3092\u8a2d\u5b9a<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;&#8221;\u30d5\u30a9\u30f3\u30c8\u540d&#8221;<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u306b\u5bfe\u3057\u3066\u6307\u5b9a\u3057\u305f\u30d5\u30a9\u30f3\u30c8\u3092\u8a2d\u5b9a<br \/>\u30d5\u30a9\u30f3\u30c8\u540d\u306f\u3001\u5fc5\u305a\u534a\u89d2\u306e\u4e8c\u91cd\u5f15\u7528\u7b26 (&#8220;) \u3067\u56f2\u307f\u307e\u3059<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;nn<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u306b\u5bfe\u3057\u3066\u6307\u5b9a\u3057\u305f\u30d5\u30a9\u30f3\u30c8\u30b5\u30a4\u30ba\u3092\u8a2d\u5b9a<br \/>nn \u306b\u306f\u3001\u30dd\u30a4\u30f3\u30c8\u6570\u3092\u8868\u3059 2 \u6841\u306e\u6570\u5024\u3092\u6307\u5b9a\u3057\u307e\u3059<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;color<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u306b\u5bfe\u3057\u3066\u6307\u5b9a\u3057\u305f\u8272\u3092\u8a2d\u5b9a<br \/>color \u306b\u306f\u300116\u9032\u6570\u306e\u8272\u306e\u5024\u3092\u300cK\u300d\u306b\u3064\u3065\u3051\u3066\u300cK00FF00\u300d\u306e\u3088\u3046\u306b\u6307\u5b9a\u3057\u307e\u3059<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;&#8221;+&#8221;<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u3092\u3001\u73fe\u5728\u306e\u30c6\u30fc\u30de\u306e [\u898b\u51fa\u3057] \u30d5\u30a9\u30f3\u30c8\u306b\u8a2d\u5b9a\u3057\u307e\u3059<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;&#8221;-&#8220;<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u3092\u3001\u73fe\u5728\u306e\u30c6\u30fc\u30de\u306e [\u672c\u6587] \u30d5\u30a9\u30f3\u30c8\u306b\u8a2d\u5b9a\u3057\u307e\u3059<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;Kxx.Syyy<\/td>\n<td width=\"450\">\u3053\u306e\u30b3\u30fc\u30c9\u306b\u7d9a\u304f\u6587\u5b57\u5217\u3092\u3001\u73fe\u5728\u306e\u30c6\u30fc\u30de\u306e\u6307\u5b9a\u3057\u305f\u8272\u306b\u8a2d\u5b9a\u3057\u307e\u3059<br \/>xx \u306f\u3001\u4f7f\u7528\u3059\u308b\u30c6\u30fc\u30de\u306e\u8272\u3092\u6307\u5b9a\u3059\u308b 2 \u6841\u306e\u6570\u5024 (1 \uff5e 12) \u3067\u3059<br \/>Syyy \u306f\u3001\u30c6\u30fc\u30de\u306e\u8272\u306e\u7db2\u639b\u3051\uff08\u6fc3\u6de1\uff09\u3092\u6307\u5b9a\u3057\u307e\u3059<br \/>\u7db2\u639b\u3051\u306e\u6fc3\u6de1\u3092\u660e\u308b\u304f\u3059\u308b\u306b\u306f\u3001S \u3092 + \u3068\u6307\u5b9a\u3057\u3001\u6697\u304f\u3059\u308b\u306b\u306f S \u3092 &#8211; \u3068\u6307\u5b9a\u3057\u307e\u3059<br \/>yyy \u306f\u30013 \u6841\u306e\u6574\u6570\u3067\u3001\u30d1\u30fc\u30bb\u30f3\u30c6\u30fc\u30b8\u3092 0 \uff5e 100 \u3067\u6307\u5b9a\u3057\u307e\u3059\u3002<br \/>\u30c6\u30fc\u30de\u306e\u8272\u307e\u305f\u306f\u7db2\u639b\u3051\u3092\u6307\u5b9a\u3059\u308b\u5024\u304c\u3053\u306e\u5236\u9650\u3092\u8d85\u3048\u308b\u5834\u5408\u306f\u3001\u6700\u3082\u8fd1\u3044\u6709\u52b9\u306a\u5024\u304c\u4f7f\u7528\u3055\u308c\u307e\u3059\u3002<\/td>\n<\/tr>\n<\/table>\n<p><\/p>\n<br \/>\n<h3><strong>\u30d8\u30c3\u30c0\u30fc\u3068\u30d5\u30c3\u30bf\u30fc\u306b\u6307\u5b9a\u3067\u304d\u308b VBA \u30b3\u30fc\u30c9<\/strong><\/h3>\n<table>\n<tr>\n<td align = \"center\" width=\"200\" bgcolor=\"#fffccc\"><strong>VBA \u30b3\u30fc\u30c9<\/strong><\/td>\n<td align = \"center\" width=\"450\" bgcolor=\"#fffccc\"><strong>\u8aac\u660e<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;D<\/td>\n<td width=\"450\">\u73fe\u5728\u306e\u65e5\u4ed8<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;T<\/td>\n<td width=\"450\">\u73fe\u5728\u306e\u6642\u523b<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;A<\/td>\n<td width=\"450\">\u30b7\u30fc\u30c8\u898b\u51fa\u3057\u540d<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;F<\/td>\n<td width=\"450\">\u30d5\u30a1\u30a4\u30eb\u306e\u540d\u524d<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;Z<\/td>\n<td width=\"450\">\u30d5\u30a1\u30a4\u30eb\u306e\u30d1\u30b9<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;N<\/td>\n<td width=\"450\">\u30d5\u30a1\u30a4\u30eb\u306e\u7dcf\u30da\u30fc\u30b8\u6570<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;P<\/td>\n<td width=\"450\">\u30da\u30fc\u30b8\u756a\u53f7<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;P+<\u6570\u5024><\/td>\n<td width=\"450\">\u30da\u30fc\u30b8\u756a\u53f7\u306b\u6307\u5b9a\u3057\u305f <\u6570\u5024> \u3092\u52a0\u3048\u305f\u5024<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;P-<\u6570\u5024><\/td>\n<td width=\"450\">\u30da\u30fc\u30b8\u756a\u53f7\u304b\u3089\u6307\u5b9a\u3057\u305f <\u6570\u5024> \u3092\u5f15\u3044\u305f\u5024<\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;&#038;<\/td>\n<td width=\"450\">\u30a2\u30f3\u30d1\u30b5\u30f3\u30c9 (&#038;) <\/td>\n<\/tr>\n<tr>\n<td width=\"200\">&#038;G<\/td>\n<td width=\"450\">\u30a4\u30e1\u30fc\u30b8\u3092\u633f\u5165<\/td>\n<\/tr>\n<\/table>\n<p><\/p>\n<br \/>\n<h3>\u66f8\u5f0f\u30b3\u30fc\u30c9\u30fbVBA \u30b3\u30fc\u30c9 \u3092\u8a18\u8ff0\u3059\u308b\u5834\u5408\u306e\u6ce8\u610f\u70b9<\/h3>\n<div class=\"m30-l\">\n<ol>\n<li>\u66f8\u5f0f\u3092\u8a2d\u5b9a\u3057\u305f\u3044\u6587\u5b57\u5217\u306e\u524d\u306b\u300c\u66f8\u5f0f\u30b3\u30fc\u30c9\u300d\u3092\u8a18\u8ff0\u3057\u307e\u3059\u3002<br \/>\n\t\u3000\u3000\uff08\u4f8b\uff09<strong>&#8220;&#038;U\u3042\u3044\u3046\u3048\u304a&#8221;<\/strong><br \/>\n\t\u3000\u3000\u300c\u3042\u3044\u3046\u3048\u304a\u300d\u306b\u3001\u4e8c\u91cd\u7dda\u3092\u8a2d\u5b9a\u3057\u307e\u3059<\/li>\n<li>\u66f8\u5f0f\u8a2d\u5b9a\u3057\u305f\u6587\u5b57\u5217\u306e\u3042\u3068\u306b\u66f8\u5f0f\u3092\u89e3\u9664\u3057\u305f\u6587\u5b57\u5217\u3092\u8a18\u8ff0\u3059\u308b\u5834\u5408\u3001\u518d\u5ea6\u300c\u66f8\u5f0f\u30b3\u30fc\u30c9\u300d\u3092\u8a18\u8ff0\u3057\u307e\u3059\uff08\u30d5\u30a9\u30f3\u30c8\u3001\u30d5\u30a9\u30f3\u30c8\u30b5\u30a4\u30ba\u3001\u6587\u5b57\u8272\u306f\u9664\u304d\u307e\u3059\uff09\u3002<br \/>\n\t\u3000\u3000\uff08\u4f8b\uff09<strong>&#8220;&#038;U\u3042\u3044\u3046\u3048\u304a&#038;U\u304b\u304d\u304f\u3051\u3053&#8221;<\/strong><br \/>\n\t\u3000\u3000\u300c\u3042\u3044\u3046\u3048\u304a\u300d\u306b\u3060\u3051\u4e8c\u91cd\u7dda\u304c\u8a2d\u5b9a\u3055\u308c\u307e\u3059\u3002<\/li>\n<li>\u6570\u5024\u304b\u3089\u59cb\u307e\u308b\u6587\u5b57\u5217\u306b\u5bfe\u3057\u3066\u30d5\u30a9\u30f3\u30c8\u30b5\u30a4\u30ba\u3092\u8a2d\u5b9a\u3059\u308b\u5834\u5408\u3001\u6570\u5024\u306e\u524d\u306b\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3092\u5165\u308c\u307e\u3059\u3002<br \/>\n\t\u3000\u3000\uff08\u4f8b\uff09<strong>&#8220;&#038;12 123456&#8221;<\/strong><br \/>\n\t\u3000\u3000\u300c123456\u300d\u306e\u6587\u5b57\u30b5\u30a4\u30ba\u3092 12 \u30dd\u30a4\u30f3\u30c8\u306b\u8a2d\u5b9a\u3057\u307e\u3059<\/li>\n<li>\u8a2d\u5b9a\u306f\u3001\u4e0a\u8a18\u4f8b\u306e\u3088\u3046\u306b\u300c&#8221;\uff08\u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c6\u30fc\u30b7\u30e7\u30f3\uff09\u300d\u3067\u56f2\u307f\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u300c&#8221;\u300d\u306b\u56f2\u307e\u308c\u305f\u4e2d\u3067\u3001\u300c&#8221;\u300d\u3092\u4f7f\u7528\u3059\u308b\u5834\u5408\u306f\u3001\u300c&#8221;&#8221;\u300d\u306e\u3088\u3046\u306b\uff12\u3064\u7d9a\u3051\u3066\u8a18\u8ff0\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<br \/>\n\t\u3000\u3000\uff08\u4f8b\uff09<strong>&#8220;&#038;&#8221;&#8221;\uff2d\uff33 \uff30\u660e\u671d&#8221;&#8221;\u3042\u3044\u3046\u3048\u304a&#8221;<\/strong><br \/>\n\t\u3000\u3000\u300c\u3042\u3044\u3046\u3048\u304a\u300d\u306e\u30d5\u30a9\u30f3\u30c8\u3092\u300c\uff2d\uff33 \uff30\u660e\u671d\u300d\u306b\u8a2d\u5b9a\u3057\u307e\u3059<\/li>\n<li>\u6587\u5b57\u5217\u306e\u30d5\u30a9\u30f3\u30c8\u3092\u9014\u4e2d\u304b\u3089\u5909\u66f4\u3059\u308b\u5834\u5408<br \/>\n\t\u3000\u3000\uff08\u4f8b\uff09<strong>&#8220;&#038;&#8221;&#8221;\uff2d\uff33 \uff30\u660e\u671d&#8221;&#8221;\u3042\u3044\u3046&#038;&#8221;&#8221;Adobe Fan Heiti Std B&#8221;&#8221;\u3048\u304a&#8221;<\/strong><br \/>\n\t\u3000\u3000\u3000\u3000\u3000\u307e\u305f\u306f\u3001<br \/>\n\t\u3000\u3000\uff08\u4f8b\uff09<strong>&#8220;&#038;&#8221;&#8221;\uff2d\uff33 \uff30\u660e\u671d&#8221;&#8221;\u3042\u3044\u3046&#8221; &#038; &#8220;&#038;&#8221;&#8221;Adobe Fan Heiti Std B&#8221;&#8221;\u3048\u304a&#8221;<\/strong><br \/>\n\t\u3000\u3000\u300c\u3042\u3044\u3046\u300d\u3092\u300c\uff2d\uff33 \uff30\u660e\u671d\u300d\u306b\u3001\u300c\u3048\u304a\u300d\u3092\u300cAdobe Fan Heiti Std B\u300d\u306b\u8a2d\u5b9a\u3057\u307e\u3059<\/li>\n<li>\u6587\u5b57\u5217\u306e\u30d5\u30a9\u30f3\u30c8\u306e\u6307\u5b9a\u306e\u5f8c\u306b\u300c,\uff08\u30ab\u30f3\u30de\uff09\u300d\u3092\u3064\u3051\u300c\u6a19\u6e96\u300d\u300c\u592a\u5b57\u300d\u300c\u659c\u4f53\u300d\u300c\u592a\u5b57 \u659c\u4f53\u300d\u306e\u3044\u305a\u308c\u304b\u3092\u6307\u5b9a\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<br \/>\n\t\u3000\u3000\uff08\u4f8b\uff09<strong>&#8220;&#038;&#8221;&#8221;\uff2d\uff33 \uff30\u660e\u671d,\u592a\u5b57 \u659c\u4f53&#8221;&#8221;&#038;D&#8221;<\/strong><br \/>\n\t\u3000\u3000\u300c\u73fe\u5728\u306e\u65e5\u4ed8\u300d\u3092\u300c\uff2d\uff33 \uff30\u660e\u671d\u300d\u300c\u592a\u5b57\u300d\u300c\u659c\u4f53\u300d\u306b\u8a2d\u5b9a\u3057\u307e\u3059<\/li>\n<\/ol><\/div>\n<\/div>\n<br \/><br \/>\n<h2>PageSetup.PrintQuality \u30d7\u30ed\u30d1\u30c6\u30a3 \u4f7f\u7528\u4f8b<\/h2>\n<div class=\"m30-l\">\n<h3 id=\"vba_sample\">\u30b5\u30f3\u30d7\u30ebVBA\u30bd\u30fc\u30b9<\/h3>\n<pre class=\"lang:vb mark:0 decode:true \" title=\"PageSetup.PrintQuality \u30d7\u30ed\u30d1\u30c6\u30a3 \u4f7f\u7528\u4f8b\" data-url=\"http:\/\/example.co.jp\" >\r\n\u3000\r\nSub Sample_HeaderFooter()\r\n\r\n    Dim w As Worksheet\r\n    Set w = ActiveSheet\r\n    \r\n    With w.PageSetup\r\n    \r\n        \r\n        '\u6587\u5b57\u5217\u300c\u4e2d\u9593\u30c6\u30b9\u30c8\u6210\u7e3e\u8868\u300d\u3092 \u592a\u5b57\u3001\u6587\u5b57\u30b5\u30a4\u30ba 16pt \u306b\u8a2d\u5b9a\u3001\u30d8\u30c3\u30c0\u30fc\u306b\u5de6\u8a70\u3081\u3067\u914d\u7f6e\r\n        .LeftHeader = \"&\"\"-,\u592a\u5b57\"\"&16\u4e2d\u9593\u30c6\u30b9\u30c8\u6210\u7e3e\u8868\"\r\n        \r\n        '\u30b7\u30fc\u30c8\u540d\u3092 \u592a\u5b57\u3001\u4e0b\u7dda \u3092\u8a2d\u5b9a\u3001\u30d8\u30c3\u30c0\u30fc\u306e\u4e2d\u592e\u306b\u914d\u7f6e\r\n        .CenterHeader = \"&B&U&A\"\r\n        \r\n        '\u73fe\u5728\u306e\u65e5\u4ed8\u30fb\u6642\u523b\u3092\u30d5\u30a9\u30f3\u30c8\u300c\u30e1\u30a4\u30ea\u30aa\u300d\u659c\u4f53 \u306b\u8a2d\u5b9a\u3001\u30d8\u30c3\u30c0\u30fc\u53f3\u8a70\u3081\u3067\u914d\u7f6e\r\n        .RightHeader = \"&\"\"\u30e1\u30a4\u30ea\u30aa,\u659c\u4f53\"\"&D &T\"\r\n        \r\n        '\u300c[\u30da\u30fc\u30b8] \/ [\u7dcf\u30da\u30fc\u30b8] \u30da\u30fc\u30b8\u300d\u3092\u30d5\u30a9\u30f3\u30c8\u8d64\u8272\u306b\u8a2d\u5b9a\u3001\u30d5\u30c3\u30bf\u30fc\u4e2d\u592e\u306b\u914d\u7f6e\r\n        .CenterFooter = \"&KFF0000&P \/ &N \u30da\u30fc\u30b8\"\r\n    \r\n    \r\n    End With\r\n    \r\n    w.PrintPreview\r\n    \r\n\r\nEnd Sub\r\n\u3000\r\n  <\/pre>\n<br \/>\n<h3>\u5b9f\u884c\u7d50\u679c<\/h3>\n<p><a href=\"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/10\/headerfootervbafont01a.jpg?ssl=1\" rel=\"lightbox[3956]\"><img loading=\"lazy\" src=\"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/10\/headerfootervbafont01a.jpg?resize=420%2C591&#038;ssl=1\" alt=\"VBA\u30b3\u30fc\u30c9\u30fb\u66f8\u5f0f\u30b3\u30fc\u30c9 \u4f7f\u7528\u4f8b\" width=\"420\" height=\"591\" class=\"alignnone size-full wp-image-3970\" srcset=\"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/10\/headerfootervbafont01a.jpg?w=420&amp;ssl=1 420w, https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/10\/headerfootervbafont01a.jpg?resize=284%2C400&amp;ssl=1 284w\" sizes=\"(max-width: 420px) 100vw, 420px\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<\/div>\n<br \/>\n","protected":false},"excerpt":{"rendered":"<p>\u5370\u5237\u8a2d\u5b9a\uff08\u30d8\u30c3\u30c0\u30fc\uff0f\u30d5\u30c3\u30bf\u30fc\uff09\u66f8\u5f0f\u30b3\u30fc\u30c9\u30fbVBA\u30b3\u30fc\u30c9 \u30d8\u30c3\u30c0\u30fc\u304a\u3088\u3073\u30d5\u30c3\u30bf\u30fc\uff08 &#8230; <\/p>\n","protected":false},"author":1,"featured_media":3970,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"amp_status":"","spay_email":"","jetpack_publicize_message":""},"categories":[357],"tags":[567,598,63,311,38,360,601,600,566,599],"jetpack_featured_media_url":"https:\/\/i1.wp.com\/excelwork.info\/excel\/wp\/wp-content\/uploads\/2015\/10\/headerfootervbafont01a.jpg?fit=420%2C591&ssl=1","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4Ye9i-11O","_links":{"self":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/3956"}],"collection":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/comments?post=3956"}],"version-history":[{"count":16,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/3956\/revisions"}],"predecessor-version":[{"id":4015,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/posts\/3956\/revisions\/4015"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media\/3970"}],"wp:attachment":[{"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/media?parent=3956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/categories?post=3956"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelwork.info\/excel\/wp-json\/wp\/v2\/tags?post=3956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}