{"id":7999,"date":"2008-03-18T09:52:00","date_gmt":"2008-03-18T09:52:00","guid":{"rendered":"http:\/\/melotopia.net\/b\/?p=7999"},"modified":"2008-03-18T09:52:00","modified_gmt":"2008-03-18T09:52:00","slug":"vba%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/melotopia.net\/b\/?p=7999","title":{"rendered":"VBA\uc2a4\ud06c\ub9bd\ud2b8"},"content":{"rendered":"<div class=\"desc\">\n<p>\n         Sub FindAndChange()<br \/>\n         <br \/>\n         Dim i As Integer<br \/>\n         <br \/>\n         Dim j As Integer<br \/>\n         <br \/>\n         For i = 1 To 10<br \/>\n         <br \/>\n         For j = 1 To 20<br \/>\n         <br \/>\n         If Worksheets(&#8220;Sheet1&#8221;).Cells(i, 2).Value = Worksheets(&#8220;Sheet2&#8221;).Cells(j, 2).Value Then<br \/>\n         <br \/>\n         Worksheets(&#8220;Sheet2&#8221;).Cells(j, 1).Value = Worksheets(&#8220;Sheet1&#8221;).Cells(i, 1).Value<br \/>\n         <br \/>\n         End If<br \/>\n         <br \/>\n         Next j<br \/>\n         <br \/>\n         Next i<br \/>\n         <br \/>\n         End Sub\n        <\/p>\n<p>         \uc74c&#8230;<br \/>\n         <br \/>\n         \uc774\uc820 VBA \uc5d1\uc140 \uc2a4\ud06c\ub9bd\ud2b8\uae4c\uc9c0 \uac74\ub4dc\ub9ac\uac8c \ub418\uc5c8\ub2e4.<br \/>\n         <br \/>\n         \uc774 \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc0c1\uc138\ud55c \uc124\uba85\uc740 \ub313\uae00 \ub2ec\ub9ac\uba74 \ucd94\uac00\ud560 \uc608\uc815\uc784.\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=802\" 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","protected":false},"excerpt":{"rendered":"<p>Sub FindAndChange() Dim i As Integer Dim j As Integer For i = 1 To 10 For j = 1 To 20 If Worksheets(&#8220;Sheet1&#8221;).Cells(i, 2).Value = Worksheets(&#8220;Sheet2&#8221;).Cells(j, 2).Value Then Worksheets(&#8220;Sheet2&#8221;).Cells(j, 1).Value = Worksheets(&#8220;Sheet1&#8221;).Cells(i, 1).Value End If Next j Next i End Sub \uc74c&#8230; \uc774\uc820 VBA \uc5d1\uc140 \uc2a4\ud06c\ub9bd\ud2b8\uae4c\uc9c0 \uac74\ub4dc\ub9ac\uac8c \ub418\uc5c8\ub2e4. \uc774 \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc0c1\uc138\ud55c \uc124\uba85\uc740 \ub313\uae00 [&hellip;]<\/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-7999","post","type-post","status-publish","format-standard","hentry","category-12"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8o6gA-251","jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/posts\/7999","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=7999"}],"version-history":[{"count":0,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=\/wp\/v2\/posts\/7999\/revisions"}],"wp:attachment":[{"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7999"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/melotopia.net\/b\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}