{"id":2210,"date":"2023-09-01T08:27:58","date_gmt":"2023-09-01T08:27:58","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/"},"modified":"2023-12-06T06:16:26","modified_gmt":"2023-12-06T06:16:26","slug":"temukan-sel-kolom-baris-terakhir","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/","title":{"rendered":"Bagaimana cara menemukan baris, kolom, dan sel terakhir?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-87460086\"><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 menemukan baris, kolom, atau sel terakhir, Anda dapat menggunakan properti \u201cAkhir\u201d dari rentang tersebut. Properti end memungkinkan Anda menavigasi ke akhir rentang data (ke sel terakhir yang tidak kosong). Dengan ini, ada konstanta yang dapat Anda gunakan untuk menentukan arah mana yang ingin Anda navigasi (atas, bawah, kiri atau kanan).<\/p><h2 class=\"wp-block-heading\"> Gunakan VBA untuk menemukan baris terakhir di Excel<\/h2><ol type=\"1\"><li> Tetapkan sel atau rentang yang ingin Anda navigasikan ke baris terakhir.<\/li><li> Setelah itu, masukkan titik untuk mendapatkan daftar properti dan metode.<\/li><li> Pilih atau ketik \u201cEnd\u201d dan masukkan tanda kurung awal.<\/li><li> Gunakan argumen apa pun yang ingin Anda gunakan.<\/li><li> Selain itu, gunakan properti alamat untuk mendapatkan alamat sel.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox Range(\"A1\").End(xlDown).Address<\/code><\/pre><p> Saat Anda menjalankan kode di atas, ini menampilkan kotak pesan dengan nomor baris sel terakhir yang tidak kosong. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54519\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-trouver-la-derniere-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan vba untuk menemukan baris terakhir\" width=\"628\" height=\"512\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Temukan kolom terakhir menggunakan VBA<\/h2><p> Sekarang katakanlah Anda ingin mencari kolom terakhir. Dalam hal ini, alih-alih menggunakan konstanta &#8220;xlDown&#8221;, Anda harus menggunakan &#8220;xlRight&#8221;, dan jika Anda ingin memilih sel itu alih-alih memiliki alamatnya, Anda dapat menggunakan metode &#8220;pilih&#8221;. Simak cara berikut ini. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").End(xlToRight).Select<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54521\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utilisez-vba-pour-trouver-la-derniere-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan vba untuk menemukan kolom terakhir\" width=\"616\" height=\"563\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Temukan sel terakhir<\/h2><p> Dengan menggunakan metode yang sama Anda juga bisa mendapatkan sel terakhir yang merupakan sel tidak kosong. Untuk menulis kode ini, Anda perlu mengetahui baris terakhir dan kolom terakhir. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_last_row() Dim lRow As Long Dim lColumn As Long lRow = Range(\"A1\").End(xlDown).Row lColumn = Range(\"A1\").End(xlToRight).Column Cells(lRow, lColumn).Select End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54522\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-trouver-la-derniere-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"temukan sel terakhir\" width=\"793\" height=\"303\"><\/figure><\/div><p> Untuk memahami kode di atas, kita perlu membaginya menjadi tiga bagian. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54523\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-code-pour-trouver-la-derniere-ligne-et-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"kode untuk menemukan baris dan kolom terakhir\" width=\"484\" height=\"336\"><\/figure><\/div><ol type=\"1\"><li> Pada bagian PERTAMA, Anda <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">mendeklarasikan dua variabel<\/a> untuk menyimpan nomor baris dan nomor kolom.<\/li><li> Di bagian KEDUA, Anda menggunakan &#8220;End&#8221; dengan &#8220;xlDown&#8221; lalu properti Row untuk mendapatkan nomor baris yang terakhir, dan dengan cara yang sama, Anda menggunakan &#8220;End&#8221; dengan &#8220;xlToRight&#8221; lalu properti \u201cKolom\u201d untuk mendapatkan nomor kolom dari kolom terakhir.<\/li><li> Di bagian KETIGA, menggunakan nomor kolom terakhir dan nomor baris terakhir, rujuk ke sel terakhir dan pilih.<\/li><\/ol><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Jika Anda ingin memilih sel di <a href=\"https:\/\/exceladvisor.org\/id\/lembar-kerja-1\/\">lembar kerja<\/a> yang berbeda menggunakan metode baris terakhir dan kolom terakhir, Anda harus <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/\">mengaktifkan lembar kerja tersebut<\/a> terlebih dahulu.<\/p><h2 class=\"wp-block-heading\"> Baris, kolom, dan sel terakhir menggunakan metode Temukan<\/h2><p> Anda juga bisa menggunakan metode find dengan objek range untuk mendapatkan baris, kolom, dan sel terakhir pada lembar kerja. Untuk mencari nomor barisnya, berikut kodenya:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_last_row() Dim iRow As Long iRow = Cells.Find(What:=\"*\", _ After:=Range(\"A1\"), _ LookAt:=xlPart, _ LookIn:=xlFormulas, _ SearchOrder:=xlByRows, _ SearchDirection:=xlPrevious, _ MatchCase:=False).Row MsgBox iRow End Sub<\/code><\/pre><p> Untuk nomor kolom:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_last_row() Dim iColumn As Long iColumn = Cells.Find(What:=\"*\", _ After:=Range(\"A1\"), _ LookAt:=xlPart, _ LookIn:=xlFormulas, _ SearchOrder:=xlByColumns, _ SearchDirection:=xlPrevious, _ MatchCase:=False).Column MsgBox iColumn End Sub<\/code><\/pre><p> Untuk mendapatkan alamat sel dari sel terakhir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_last_row() Dim iColumn As Long Dim iRow As Long iColumn = Cells.Find(What:=\"*\", _ After:=Range(\"A1\"), _ LookAt:=xlPart, _ LookIn:=xlFormulas, _ SearchOrder:=xlByColumns, _ SearchDirection:=xlPrevious, _ MatchCase:=False).Column iRow = Cells.Find(What:=\"*\", _ After:=Range(\"A1\"), _ LookAt:=xlPart, _ LookIn:=xlFormulas, _ SearchOrder:=xlByRows, _ SearchDirection:=xlPrevious, _ MatchCase:=False).Row Cells(iRow, iColumn).Address End Sub<\/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-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-baris\/\">Hitung baris menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/\">Font Excel VBA (warna, ukuran, jenis dan tebal)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sembunyikan-tampilkan-baris-kolom\/\">Excel VBA Sembunyikan dan tampilkan kolom atau baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rentang-1\/\">Rentang VBA Excel \u2013 Bekerja dengan Rentang dan Sel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/perbatasan\/\">Terapkan batas ke sel menggunakan VBA di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-2210","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>Bagaimana cara menemukan baris, kolom, dan sel terakhir di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini menunjukkan cara menggunakan VBA untuk menemukan baris terakhir, kolom terakhir, dan sel terakhir lembar kerja.\" \/>\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\/temukan-sel-kolom-baris-terakhir\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menemukan baris, kolom, dan sel terakhir di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menunjukkan cara menggunakan VBA untuk menemukan baris terakhir, kolom terakhir, dan sel terakhir lembar kerja.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-trouver-la-derniere-ligne.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=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/\",\"name\":\"Bagaimana cara menemukan baris, kolom, dan sel terakhir di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-trouver-la-derniere-ligne.png\",\"datePublished\":\"2023-09-01T08:27:58+00:00\",\"dateModified\":\"2023-12-06T06:16:26+00:00\",\"description\":\"Tutorial ini menunjukkan cara menggunakan VBA untuk menemukan baris terakhir, kolom terakhir, dan sel terakhir lembar kerja.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-trouver-la-derniere-ligne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-trouver-la-derniere-ligne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menemukan baris, kolom, dan sel terakhir?\"}]},{\"@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":"Bagaimana cara menemukan baris, kolom, dan sel terakhir di Excel?","description":"Tutorial ini menunjukkan cara menggunakan VBA untuk menemukan baris terakhir, kolom terakhir, dan sel terakhir lembar kerja.","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\/temukan-sel-kolom-baris-terakhir\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menemukan baris, kolom, dan sel terakhir di Excel?","og_description":"Tutorial ini menunjukkan cara menggunakan VBA untuk menemukan baris terakhir, kolom terakhir, dan sel terakhir lembar kerja.","og_url":"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-trouver-la-derniere-ligne.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/","url":"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/","name":"Bagaimana cara menemukan baris, kolom, dan sel terakhir di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-trouver-la-derniere-ligne.png","datePublished":"2023-09-01T08:27:58+00:00","dateModified":"2023-12-06T06:16:26+00:00","description":"Tutorial ini menunjukkan cara menggunakan VBA untuk menemukan baris terakhir, kolom terakhir, dan sel terakhir lembar kerja.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-trouver-la-derniere-ligne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-vba-pour-trouver-la-derniere-ligne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menemukan baris, kolom, dan sel terakhir?"}]},{"@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\/2210","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=2210"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2210\/revisions"}],"predecessor-version":[{"id":2533,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2210\/revisions\/2533"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}