{"id":2066,"date":"2023-10-21T10:50:35","date_gmt":"2023-10-21T10:50:35","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/"},"modified":"2023-12-06T06:18:36","modified_gmt":"2023-12-06T06:18:36","slug":"urutkan-rentangnya","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/","title":{"rendered":"Bagaimana cara mengurutkan rentang di vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2821879858\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Untuk mengurutkan rentang sel menggunakan VBA, Anda perlu menggunakan metode \u201cSORT\u201d yang memungkinkan Anda mengatur satu kunci (kolom) atau beberapa kunci (untuk beberapa kolom) untuk mengurutkan. Anda juga dapat mengatur urutan (menaik atau menurun) yang ingin Anda urutkan, dan Anda dapat menentukan apakah Anda memiliki header atau tidak.<\/p><h2 class=\"wp-block-heading\"> Urutkan rentang dengan VBA<\/h2><ol type=\"1\"><li> Gunakan objek rentang untuk menentukan rentang yang ingin Anda urutkan.<\/li><li> Ketik titik dan masukkan metode pengurutan.<\/li><li> Tentukan kunci yang ingin Anda gunakan untuk mengurutkan.<\/li><li> Tetapkan urutan pengurutan.<\/li><li> Sebutkan apakah Anda memiliki header atau tidak. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54924\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengurutkan rentang berdasarkan vba\" width=\"690\" height=\"296\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A11\").Sort Key1:=Range(\"A1\"), _ Order1:=xlAscending, _ Header:=xlYes<\/code><\/pre><p> Dalam kode di atas Anda menggunakan rentang A1:A11, dan dalam metode pengurutan Anda menggunakan urutan menaik, disebutkan bahwa Anda memiliki header dalam rentang tersebut.<\/p><h2 class=\"wp-block-heading\"> Memahami metode pengurutan VBA<\/h2><p> Sebelum menulis makro untuk mengurutkan suatu rentang, yang terbaik adalah mempelajari metode pengurutan dan memahami argumennya.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sort (Key1, Order1, Key2, Type, Order2, Key3, Order3, _ Header, OrderCustom, MatchCase, Orientation, SortMethod, _ DataOption1, DataOption2, DataOption3)<\/code><\/pre><p> Berikut adalah argumen terpenting yang akan Anda gunakan dalam kehidupan nyata.<\/p><ul><li> <strong>Kunci<\/strong> : Di sini Anda perlu menentukan sel yang kolomnya ingin Anda gunakan sebagai dasar pengurutan.<\/li><li> <strong>Urutan<\/strong> : Urutan kolom yang ingin Anda urutkan (ascending\/descending).<\/li><li> <strong>Header<\/strong> : Sebuah konstanta untuk menentukan apakah Anda memiliki header atau tidak atau ingin VBA menebaknya.<\/li><\/ul><h2 class=\"wp-block-heading\"> Urutkan dalam urutan menurun<\/h2><p> Pada kode berikut, saya menggunakan &#8216;xlDescending&#8217; untuk mengurutkan kolom jumlah dalam urutan menurun. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54925\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-tri-decroissant.png\" sizes=\"auto, \" srcset=\"\" alt=\"Urutkan dalam urutan menurun\" width=\"498\" height=\"216\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A13\").Sort Key1:=Range(\"A1\"), _ Order1:=xlDescending, _ Orientation:=xlSortColumns<\/code><\/pre><h2 class=\"wp-block-heading\"> Menggunakan beberapa kolom (kunci) untuk mengurutkan<\/h2><p> Anda juga dapat menggunakan beberapa kolom untuk mengurutkan rentang. Mari kita ambil contoh dari tabel di bawah ini di mana Anda memiliki beberapa entri dengan nama karyawan dan kota, dan Anda perlu mengurutkannya berdasarkan nama dan kota. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54926\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-utiliser-plusieurs-colonnes-pour-trier.png\" sizes=\"auto, \" srcset=\"\" alt=\"Gunakan beberapa kolom untuk mengurutkan\" width=\"371\" height=\"410\"><\/figure><\/div><p> Berikut adalah kode yang perlu Anda gunakan: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54927\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-codes-pour-plusieurs-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"kode untuk beberapa kolom\" width=\"538\" height=\"276\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:C13\").Sort Key1:=Range(\"A1\"), _ Order1:=xlAscending, _ Key2:=Range(\"B1\"), _ Order1:=xlAscending, _ Header:=xlYes<\/code><\/pre><p> Seperti yang Anda lihat di kode, Anda memiliki key1 dan key2. Di key1 Anda memiliki kolom dengan nama karyawan, dan di key2 Anda memiliki kolom kota. Untuk kedua kolom, urutannya menaik dan headernya ada.<\/p><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Anda dapat menggunakan ini sebagai kolom mana pun yang ingin Anda gunakan sebagai dasar pengurutan menggunakan kunci dan urutan.<\/p><h2 class=\"wp-block-heading\"> Mengubah orientasi nasib<\/h2><p> Saat Anda biasanya mengurutkan data di Excel, secara default Anda bisa mengurutkan menggunakan kolom. Namun dari opsi pengurutan, Anda dapat mengubah orientasi pengurutan dari kiri ke kanan, bukan dari atas ke bawah. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54928\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-trier-lorientation.png\" sizes=\"auto, \" srcset=\"\" alt=\"orientasi nasib\" width=\"494\" height=\"230\"><\/figure><\/div><p> Demikian pula, Anda memiliki argumen dalam metode sortir untuk mengubah orientasi ( <a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.xlsortorientation\" target=\"_blank\" rel=\"noreferrer noopener\">link<\/a> ). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54929\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-methodes-pour-trier-lorientation.png\" sizes=\"auto, \" srcset=\"\" alt=\"metode untuk mengurutkan orientasi\" width=\"642\" height=\"275\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:C13\").Sort Key1:=Range(\"A1\"), _ Order1:=xlAscending, _ Orientation:=xlSortRows<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/masukkan-kolom\/\">Kolom Sisipkan VBA (Tunggal dan Berganda)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bernama-pantai\/\">Rentang bernama VBA | (Statis + Seleksi + Dinamis)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pergeseran-jangkauan\/\">Pengimbangan Rentang VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/\">Teks Bungkus VBA (sel, rentang, dan seluruh lembar kerja)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/periksa-sel-kosong\/\">VBA Periksa apakah sel kosong + banyak sel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2066","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara mengurutkan rentang di VBA? (Menurun, Orientasi Penyortiran)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menunjukkan kepada Anda cara mengurutkan satu kolom, beberapa kolom menggunakan VBA dan cara mengubah orientasi pengurutan juga.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara mengurutkan rentang di VBA? (Menurun, Orientasi Penyortiran)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menunjukkan kepada Anda cara mengurutkan satu kolom, beberapa kolom menggunakan VBA dan cara mengubah orientasi pengurutan juga.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/\",\"name\":\"\u25b7 Bagaimana cara mengurutkan rentang di VBA? (Menurun, Orientasi Penyortiran)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png\",\"datePublished\":\"2023-10-21T10:50:35+00:00\",\"dateModified\":\"2023-12-06T06:18:36+00:00\",\"description\":\"Tutorial ini menunjukkan kepada Anda cara mengurutkan satu kolom, beberapa kolom menggunakan VBA dan cara mengubah orientasi pengurutan juga.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengurutkan rentang di vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara mengurutkan rentang di VBA? (Menurun, Orientasi Penyortiran)","description":"Tutorial ini menunjukkan kepada Anda cara mengurutkan satu kolom, beberapa kolom menggunakan VBA dan cara mengubah orientasi pengurutan juga.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mengurutkan rentang di VBA? (Menurun, Orientasi Penyortiran)","og_description":"Tutorial ini menunjukkan kepada Anda cara mengurutkan satu kolom, beberapa kolom menggunakan VBA dan cara mengubah orientasi pengurutan juga.","og_url":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:36+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/","url":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/","name":"\u25b7 Bagaimana cara mengurutkan rentang di VBA? (Menurun, Orientasi Penyortiran)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png","datePublished":"2023-10-21T10:50:35+00:00","dateModified":"2023-12-06T06:18:36+00:00","description":"Tutorial ini menunjukkan kepada Anda cara mengurutkan satu kolom, beberapa kolom menggunakan VBA dan cara mengubah orientasi pengurutan juga.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-trier-une-plage-par-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengurutkan rentang di vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2066","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2066"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2066\/revisions"}],"predecessor-version":[{"id":2746,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2066\/revisions\/2746"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}