{"id":4869,"date":"2023-07-07T01:08:15","date_gmt":"2023-07-07T01:08:15","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/"},"modified":"2023-07-07T01:08:15","modified_gmt":"2023-07-07T01:08:15","slug":"vba-mendapatkan-nomor-baris-rentang","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/","title":{"rendered":"Vba: cara mendapatkan nomor baris dari suatu rentang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk mendapatkan nomor baris dari suatu rentang di Excel menggunakan VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Dapatkan nomor baris dari rentang tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubGetRowNumber<\/span> ()\n\nrowNum = Range(\" <span style=\"color: #ff0000;\">D7<\/span> \").Row\nMsgBox rowNum\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menampilkan kotak pesan dengan nomor baris yang sesuai dengan sel <strong>D7<\/strong> , yaitu <strong>7<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Dapatkan nomor baris dari rentang yang dipilih saat ini<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubGetRowNumber<\/span> ()\n\nrowNum = Selection.Row\nMsgBox rowNum\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan menampilkan kotak pesan dengan nomor baris yang sesuai dengan rentang yang dipilih saat ini di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, jika sel <strong>B3<\/strong> dipilih saat Anda menjalankan makro ini, kotak pesan akan muncul dengan nilai <strong>3<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Dapatkan nomor baris dari rentang tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mendapatkan nomor baris untuk referensi sel <strong>D7<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubGetRowNumber<\/span> ()\n\nrowNum = Range(\" <span style=\"color: #ff0000;\">D7<\/span> \").Row\nMsgBox rowNum\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38029 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ro1.png\" alt=\"\" width=\"531\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kotak pesan menampilkan nilai <strong>7<\/strong> , yang sesuai dengan nomor baris referensi sel <strong>D7<\/strong> .<\/span><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Dapatkan nomor baris dari rentang yang dipilih saat ini<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mendapatkan nomor baris dari sel yang sedang aktif.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubGetRowNumber<\/span> ()\n\nrowNum = Selection.Row\nMsgBox rowNum\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Asumsikan sel <strong>B3<\/strong> saat ini dipilih.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38030 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ro2.png\" alt=\"\" width=\"540\" height=\"387\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kotak pesan menampilkan nilai <strong>3<\/strong> , yang sesuai dengan nomor baris sel <strong>B3<\/strong> yang sedang aktif.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menyalin-baris-yang-terlihat-ke-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menyalin garis yang terlihat ke lembar lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/garis-sorot-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menyorot garis<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk mendapatkan nomor baris dari suatu rentang di Excel menggunakan VBA: Metode 1: Dapatkan nomor baris dari rentang tertentu SubGetRowNumber () rowNum = Range(&#8221; D7 &#8220;).Row MsgBox rowNum End Sub Makro khusus ini akan menampilkan kotak pesan dengan nomor baris yang sesuai dengan sel D7 , yaitu 7 . Metode [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: Cara mendapatkan nomor baris dari suatu rentang - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mendapatkan nomor baris dari suatu range di Excel menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara mendapatkan nomor baris dari suatu rentang - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mendapatkan nomor baris dari suatu range di Excel menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T01:08:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ro1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/\",\"name\":\"VBA: Cara mendapatkan nomor baris dari suatu rentang - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T01:08:15+00:00\",\"dateModified\":\"2023-07-07T01:08:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mendapatkan nomor baris dari suatu range di Excel menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara mendapatkan nomor baris dari suatu rentang\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA: Cara mendapatkan nomor baris dari suatu rentang - Statorial","description":"Tutorial ini menjelaskan cara mendapatkan nomor baris dari suatu range di Excel menggunakan VBA, dengan beberapa contoh.","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:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara mendapatkan nomor baris dari suatu rentang - Statorial","og_description":"Tutorial ini menjelaskan cara mendapatkan nomor baris dari suatu range di Excel menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/","og_site_name":"Statorials","article_published_time":"2023-07-07T01:08:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ro1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/","url":"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/","name":"VBA: Cara mendapatkan nomor baris dari suatu rentang - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T01:08:15+00:00","dateModified":"2023-07-07T01:08:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mendapatkan nomor baris dari suatu range di Excel menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-mendapatkan-nomor-baris-rentang\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara mendapatkan nomor baris dari suatu rentang"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4869"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4869"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4869\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}