{"id":10767,"date":"2015-09-23T02:59:00","date_gmt":"2015-09-23T02:59:00","guid":{"rendered":"http:\/\/melotopia.net\/b\/?p=10767"},"modified":"2015-09-23T02:59:00","modified_gmt":"2015-09-23T02:59:00","slug":"%ec%9c%84%ec%97%90%ec%84%9c-%ec%95%84%eb%9e%98%eb%a1%9c-%ec%b1%84%ec%9b%8c%ec%a3%bc%eb%8a%94-vba","status":"publish","type":"post","link":"http:\/\/melotopia.net\/b\/?p=10767","title":{"rendered":"\uc704\uc5d0\uc11c \uc544\ub798\ub85c \ucc44\uc6cc\uc8fc\ub294 VBA"},"content":{"rendered":"<div class=\"desc\">\n<div class=\"tt_article_useless_p_margin\">\n<p>\n          \uc5d1\uc140 VBA\ub294 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc778\uc9c0 \ub9e4\ud06c\ub85c\uc778\uc9c0 \uc798 \ubaa8\ub974\uaca0\uc9c0\ub9cc, \uac15\ub825\ud558\uae34 \ud558\ub2e4.\n         <\/p>\n<p>\n\n<\/p>\n<p>\n          Sub copyandpast()<br \/>\n          <br \/>\n          i = 5<br \/>\n          <br \/>\n          Do While i < 400\n          <br \/>\n          For j = 2 To 23<br \/>\n          <br \/>\n          If Cells(i, j).Value = &#8220;&#8221; Then<br \/>\n          <br \/>\n          Cells(i, j).Value = Cells(i &#8211; 1, j).Value<br \/>\n          <br \/>\n          End If<br \/>\n          <br \/>\n          Next j<br \/>\n          <br \/>\n          i = i + 1<br \/>\n          <br \/>\n          Loop<br \/>\n          <br \/>\n          End Sub<\/p>\n<p>\n          \uc774 \ucf54\ub4dc\ub294 \ub2e4\uc74c\uc904\uc774 \ube48\uce78\uc774\uba74 \uadf8 \uc717\uc904\uc5d0\uc11c \ucc3e\uc544\ub2e4\uac00 \ucc44\uc6cc\uc8fc\ub294 \ucf54\ub4dc\uc774\ub2e4. \uc989, \ud30c\uc77c\uc774 \ube48\uce78\uc5c6\uc774 \ucc44\uc6cc\uc9c4\ub2e4.\n         <\/p>\n<p>\n\n<\/p>\n<p>         \uc2e4\uc81c \uc0ac\uc6a9\uc2dc\uc5d0\ub294 \uc800\uae30 5, 400, 2, 23\uacfc \uac19\uc740 \uc22b\uc790\ub4e4\uc744 \uace0\uccd0\uc11c \uc4f0\uba74 \ub41c\ub2e4.<br \/>\n         <\/p>\n<p>\n\n<\/p>\n<p>\n\n<\/p>\n<p>\n\n<\/p>\n<div style=\"width:100%;margin-top:30px;clear:both;height:30px\">\n<div style=\"width:31px;float:left;\">\n<a href=\"\/toolbar\/popup\/abuseReport\/?entryId=3611\" onclick=\"window.open(this.href, 'tistoryThisBlogPopup', 'width=550, height=510, toolbar=no, menubar=no, status=no, scrollbars=no'); return false;\"><br \/>\n<img data-recalc-dims=\"1\" decoding=\"async\" alt=\"\uc2e0\uace0\" src=\"https:\/\/i0.wp.com\/t1.daumcdn.net\/tistory_admin\/static\/ico\/ico_spam_report.png\" style=\"border:0\"\/><br \/>\n<\/a>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\uc5d1\uc140 VBA\ub294 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc778\uc9c0 \ub9e4\ud06c\ub85c\uc778\uc9c0 \uc798 \ubaa8\ub974\uaca0\uc9c0\ub9cc, \uac15\ub825\ud558\uae34 \ud558\ub2e4. Sub copyandpast() i = 5 Do While i < 400 For j = 2 To 23 If Cells(i, j).Value = &#8220;&#8221; Then Cells(i, j).Value = Cells(i &#8211; 1, j).Value End If Next j i = i + 1 Loop End Sub \uc774 \ucf54\ub4dc\ub294 \ub2e4\uc74c\uc904\uc774 \ube48\uce78\uc774\uba74 \uadf8 [&hellip;]\n<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[12],"tags":[],"class_list":["post-10767","post","type-post","status-publish","format-standard","hentry","category-12"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8o6gA-2NF","jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/posts\/10767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10767"}],"version-history":[{"count":0,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/posts\/10767\/revisions"}],"wp:attachment":[{"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10767"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}