{"id":205,"date":"2022-05-27T15:02:02","date_gmt":"2022-05-27T07:02:02","guid":{"rendered":"https:\/\/www.01j.top\/?p=205"},"modified":"2022-05-27T15:02:03","modified_gmt":"2022-05-27T07:02:03","slug":"excel%e5%a6%82%e4%bd%95%e4%b8%80%e6%ac%a1%e6%80%a7%e6%89%b9%e9%87%8f%e5%ae%9e%e7%8e%b0%e5%af%b9%e5%a4%9a%e4%b8%aa%e5%86%85%e5%ae%b9%e7%9a%84%e6%9f%a5%e6%89%be%e5%b9%b6%e6%9b%bf%e6%8d%a2","status":"publish","type":"post","link":"https:\/\/www.01j.top\/?p=205","title":{"rendered":"Excel\u5982\u4f55\u4e00\u6b21\u6027\u6279\u91cf\u5b9e\u73b0\u5bf9\u591a\u4e2a\u5185\u5bb9\u7684\u201c\u67e5\u627e\u5e76\u66ff\u6362\u201d\uff1f"},"content":{"rendered":"\n<p class=\"is-style-text-indent-default\">1\u804c\u573a\u5b9e\u4f8b<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u4eca\u5929\u5c0f\u7f16\u9047\u5230\u4e86\u8fd9\u6837\u7684\u4e00\u4e2a\u95ee\u9898\uff1a<\/strong><br>Excel\u5982\u4f55<strong>\u4e00\u6b21\u6027\u6279\u91cf<\/strong>\u5b9e\u73b0\u5bf9\u591a\u4e2a\u5185\u5bb9\u7684\u201c<strong>\u67e5\u627e\u5e76\u66ff\u6362<\/strong>\u201d\uff1f<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u5b9e\u9645\u5de5\u4f5c\u573a\u666f\u4e2d\uff0c\u9700\u8981\u4e00\u6b21\u6027\u6279\u91cf\u5b9e\u73b0\u5bf9100\u591a\u4e2a\u5185\u5bb9\u7684\u201c\u67e5\u627e\u5e76\u66ff\u6362\u201d\u3002<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u6211\u4eec\u7528\u51e0\u7ec4\u7b80\u5355\u7684\u6570\u636e\u6765\u6a21\u62df\u5b9e\u9645\u573a\u666f\uff0c\u8bb2\u89e3\u4e00\u4e0b\u8fd9\u4e2a\u95ee\u9898\u3002<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u5982\u4e0b\u56fe\u6240\u793a\uff1a<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>B\u5217<\/strong>\u4e3a\u6211\u4eec\u60f3\u8981\u67e5\u627e\u66ff\u6362\u7684<strong>\u6570\u636e\u6e90<\/strong>\uff0c\u6211\u4eec\u60f3\u8981\u6309\u7167<strong>G:H\u5217\u7684\u67e5\u627e\u66ff\u6362\u8981\u6c42<\/strong>\uff0c\u67e5\u627eB\u5217\u7684\u5185\u5bb9\uff1a<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u5c06\u201cExcel\u201d\u66ff\u6362\u4e3a\u201cE\u201d<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u5c06\u201cWord\u201d\u66ff\u6362\u4e3a\u201cW\u201d<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u5c06\u201cPPT\u201d\u66ff\u6362\u4e3a\u201cP\u201d<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">\u6700\u540e\u66ff\u6362\u5b8c\u6210\u7684\u6570\u636e\u5982<strong>D\u5217<\/strong>\u6240\u793a\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/pic3.zhimg.com\/80\/v2-6b3e7ea1401ea8840a610327c987c74e_720w.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"is-style-text-indent-default\">\u6211\u4eec\u6700\u901a\u5e38\u7684\u505a\u6cd5\u5c31\u662f\u901a\u8fc7<strong>\u5feb\u6377\u952e\u201cCtrl+H\u201d<\/strong>\u8c03\u51fa\u201c<strong>\u67e5\u627e\u548c\u66ff\u6362<\/strong>\u201d\u7684\u5bf9\u8bdd\u6846\uff0c\u901a\u8fc7<strong>3\u6b21<\/strong>\u67e5\u627e\u548c\u66ff\u6362\uff0c\u5b8c\u6210\u8fd9\u6837\u7684\u4efb\u52a1\u3002<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u7b2c\u4e00\u6b21\u67e5\u627e\u548c\u66ff\u6362\uff1a<\/strong>\u67e5\u627e\u201cExcel\u201d\u66ff\u6362\u4e3a\u201cE\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/pic2.zhimg.com\/80\/v2-0e69677333464e8b2e6b64ae6e4d7d35_720w.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u7b2c\u4e8c\u6b21\u67e5\u627e\u548c\u66ff\u6362\uff1a<\/strong>\u67e5\u627e\u201cWord\u201d\u66ff\u6362\u4e3a\u201cW\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/pic4.zhimg.com\/80\/v2-10e701e2d380cd02b7197f0f24dd08ab_720w.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u7b2c\u4e09\u6b21\u67e5\u627e\u548c\u66ff\u6362\uff1a<\/strong>\u67e5\u627e\u201cPPT\u201d\u66ff\u6362\u4e3a\u201cP\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/pic4.zhimg.com\/80\/v2-e0149321b9ec67247f335d2eb86166e7_720w.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u5982\u679c\u6211\u4eec\u6309\u7167\u4e0a\u9762\u8fd9\u6837\u7684\u64cd\u4f5c\u65b9\u6cd5<\/strong>\uff0c\u9047\u5230\u9700\u8981\u4e00\u6b21\u6027\u6279\u91cf\u5b9e\u73b0\u5bf9100\u591a\u4e2a\u5185\u5bb9\u7684\u201c\u67e5\u627e\u5e76\u66ff\u6362\u201d\u7684\u8bdd\uff0c<strong>\u90a3\u6548\u7387\u5c31\u592a\u4f4e\u4e86\u3002<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">2\u95ee\u9898\u89e3\u7b54<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u89e3\u51b3\u8fd9\u6837\u7684\u95ee\u9898\uff0c\u8fd8\u662f\u7528VBA\u4ee3\u7801\u5feb\u901f\u7684\u5b9e\u73b0\u5427\u3002<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">01.<strong>\u51c6\u5907\u5bf9\u5e94\u8868<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">\u9996\u5148\u6211\u4eec\u9700\u8981\u5728G:H\u5217\u51c6\u5907\u597d<strong>\u67e5\u627e\u5185\u5bb9<\/strong>\u548c<strong>\u66ff\u6362\u4e3a\u5185\u5bb9<\/strong>\u7684<strong>\u5bf9\u5e94\u8868<\/strong>\u3002<strong>\u5982\u4e0b\u56fe\u6240\u793a<\/strong>\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/pic1.zhimg.com\/80\/v2-459634856e895b8f71deaeec7238b918_720w.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"is-style-text-indent-default\">02.<strong>\u8fdb\u5165VBA\u4ee3\u7801\u7f16\u8f91\u5668<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">\u9f20\u6807\u53f3\u51fb\u5de5\u4f5c\u8868\u540d\u79f0\u6807\u7b7e\uff0c\u70b9\u51fb\u3010\u67e5\u770b\u4ee3\u7801\u3011\u547d\u4ee4\uff08\u6216\u6309\u5feb\u6377\u952eAlt+F11\u952e\uff09\u8fdb\u5165VBA\u4ee3\u7801\u7f16\u8f91\u5668\u7684\u7a97\u53e3\u3002<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">03.<strong>\u590d\u5236\u5e76\u7c98\u8d34\u4ee3\u7801<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">\u590d\u5236\u4e0b\u9762\u7684\u90a3\u6bb5VBA\u4ee3\u7801\u5e76\u7c98\u8d34\u81f3VBA\u4ee3\u7801\u7f16\u8f91\u5668\u7a97\u53e3\u5185\u3002<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">04.<strong>\u8fd0\u884c\u4ee3\u7801<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">\u70b9\u51fb\u4ee3\u7801\u5668\u7a97\u53e3\u4e0a\u65b9\u7684\u3010\u8fd0\u884c-\u8fd0\u884c\u5b50\u8fc7\u7a0b\/\u7528\u6237\u7a97\u4f53\u3011\u547d\u4ee4\u3002<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u4ee3\u7801\u5982\u4e0b\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub \u516c\u4f17\u53f7Excel\u60c5\u62a5\u5c40()\nDim arr, brr, j&amp;, i&amp;\narr = Range(\"G2:H4\"): brr = Range(\"B2:B7\")\nFor j = 1 To UBound(brr)\nFor i = 1 To UBound(arr)\nbrr(j, 1) = Replace(brr(j, 1), arr(i, 1), arr(i, 2))\nNext i\nNext j\nRange(\"B2:B7\").Value = brr\nEnd Sub<\/code><\/pre>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u5177\u4f53\u64cd\u4f5c\u6b65\u9aa4\uff0c\u5982\u4e0b\u52a8\u56fe\u6240\u793a\uff1a<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/pic2.zhimg.com\/v2-7605acfb94e77577ba0863aecf6bf087_720w.jpg?source=d16d100b\" alt=\"\u52a8\u56fe\u5c01\u9762\"\/><\/figure>\n\n\n\n<p class=\"is-style-text-indent-default\">3\u4ee3\u7801\u91ca\u4e49<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">01.<strong>\u67e5\u627e\u548c\u66ff\u6362\u4e3a\u5bf9\u5e94\u8868\u7684\u533a\u57df<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u4ee3\u7801\uff1a<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">arr = Range(&#8220;<strong>G2:H4<\/strong>&#8220;): brr = Range(&#8220;B2:B7&#8221;)<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">\u5176\u4e2d<strong>G2:H4<\/strong>\u4ee3\u8868<strong>\u67e5\u627e\u548c\u66ff\u6362\u4e3a\u5bf9\u5e94\u8868<\/strong>\u7684\u533a\u57df\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/pic2.zhimg.com\/80\/v2-c8180765ff5ed1fffb4966772649bd5d_720w.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"is-style-text-indent-default\">02.<strong>\u67e5\u627e\u7684\u533a\u57df<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\"><strong>\u4ee3\u7801\uff1a<\/strong>arr = Range(&#8220;G2:H4&#8221;): brr = Range(&#8220;<strong>B2:B7<\/strong>&#8220;)<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">\u5176\u4e2d<strong>B2:B7<\/strong>\u4ee3\u8868<strong>\u67e5\u627e\u7684\u533a\u57df<\/strong>\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/pic1.zhimg.com\/80\/v2-e501bbe223da67cd5bb051533d11b72c_720w.jpg\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"is-style-text-indent-default\">03.<strong>\u67e5\u627e\u66ff\u6362\u540e\u653e\u7f6e\u6570\u636e\u7684\u533a\u57df<\/strong><\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">\u4ee3\u7801\uff1aRange(&#8220;<strong>B2:B7<\/strong>&#8220;).Value = brr<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">\u5176\u4e2d<strong>B2:B7<\/strong>\u4ee3\u8868<strong>\u67e5\u627e\u66ff\u6362\u540e\u653e\u7f6e\u6570\u636e\u7684\u533a\u57df<\/strong>\u3002<\/p>\n\n\n\n<p class=\"is-style-text-indent-default\">\u672c\u4f8b\u4e2d\u5728\u67e5\u627e\u7684\u6570\u636e\u6e90B\u5217\u4e0a\u76f4\u63a5\u8fdb\u884c\u67e5\u627e\u66ff\u6362\uff0c\u6240\u4ee5\u67e5\u627e\u66ff\u6362\u540e\u653e\u7f6e\u6570\u636e\u7684\u533a\u57dfB2:B7\uff0c\u4e0e\u67e5\u627e\u7684\u533a\u57dfB2:B7\u91cd\u5408\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img src=\"https:\/\/pic4.zhimg.com\/80\/v2-0cae393a59a365d34f8ac87c4d69532f_720w.jpg\" alt=\"\u9cb8\u5e74\u7f51\u7edc\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>1\u804c\u573a\u5b9e\u4f8b \u4eca\u5929\u5c0f\u7f16\u9047\u5230\u4e86\u8fd9\u6837\u7684\u4e00\u4e2a\u95ee\u9898\uff1aExcel\u5982\u4f55\u4e00\u6b21\u6027\u6279\u91cf\u5b9e\u73b0\u5bf9\u591a\u4e2a\u5185\u5bb9\u7684\u201c\u67e5\u627e\u5e76\u66ff\u6362\u201d\uff1f \u5b9e\u9645\u5de5\u4f5c\u573a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[32],"tags":[],"_links":{"self":[{"href":"https:\/\/www.01j.top\/index.php?rest_route=\/wp\/v2\/posts\/205"}],"collection":[{"href":"https:\/\/www.01j.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.01j.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.01j.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.01j.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=205"}],"version-history":[{"count":1,"href":"https:\/\/www.01j.top\/index.php?rest_route=\/wp\/v2\/posts\/205\/revisions"}],"predecessor-version":[{"id":206,"href":"https:\/\/www.01j.top\/index.php?rest_route=\/wp\/v2\/posts\/205\/revisions\/206"}],"wp:attachment":[{"href":"https:\/\/www.01j.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.01j.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.01j.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}