{"id":4414,"date":"2023-07-11T07:12:37","date_gmt":"2023-07-11T07:12:37","guid":{"rendered":"https:\/\/statorials.org\/id\/tinggi-garis-vba\/"},"modified":"2023-07-11T07:12:37","modified_gmt":"2023-07-11T07:12:37","slug":"tinggi-garis-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tinggi-garis-vba\/","title":{"rendered":"Cara mengubah tinggi baris di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk mengubah tinggi baris di Excel menggunakan VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Ubah tinggi baris<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeRowHeight<\/span> ()\nRows(3).RowHeight = 40\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini mengubah ketinggian baris ketiga menjadi <strong>40<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Tinggi baris default di Excel adalah <strong>14.4<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Ubah Ketinggian Beberapa Baris<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeRowHeight<\/span> ()\nRows(\" <span style=\"color: #ff0000;\">1:5<\/span> \").RowHeight = 40\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini mengubah tinggi setiap baris dari satu menjadi lima menjadi <strong>40<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Secara otomatis menyesuaikan ketinggian beberapa baris<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeRowHeight<\/span> ()\nRows(\" <span style=\"color: #ff0000;\">1:8<\/span> \").AutoFit\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini secara otomatis menyesuaikan tinggi setiap baris dari satu hingga delapan sehingga setinggi yang diperlukan untuk menampilkan teks tertinggi di setiap baris.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan masing-masing metode ini dalam praktik dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34594 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cw1.jpg\" alt=\"\" width=\"527\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong> <a href=\"https:\/\/statorials.org\/id\/lebar-kolom-vba\/\" target=\"_blank\" rel=\"noopener\">Cara Mengubah Lebar Kolom di VBA<\/a><\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Mengubah tinggi suatu baris<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk mengubah tinggi baris ketiga menjadi 40:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeRowHeight<\/span> ()\nRows(3).RowHeight = 40\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-34603 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rh1.jpg\" alt=\"\" width=\"503\" height=\"446\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya tinggi baris ketiga yang ditingkatkan menjadi 40 sedangkan tinggi semua baris lainnya tetap sama.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Mengubah tinggi beberapa garis<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk mengubah tinggi setiap baris dari satu menjadi lima menjadi 40:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeRowHeight<\/span> ()\nRows(\" <span style=\"color: #ff0000;\">1:5<\/span> \").RowHeight = 40 \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-34604 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rh2.jpg\" alt=\"\" width=\"525\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa tinggi masing-masing dari lima baris pertama telah berubah menjadi 40 sedangkan tinggi semua baris lainnya tetap sama.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Secara otomatis menyesuaikan ketinggian beberapa baris<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk secara otomatis menyesuaikan tinggi masing-masing delapan baris pertama sehingga setinggi yang diperlukan untuk menampilkan teks tertinggi di setiap baris:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeRowHeight<\/span> ()\nRows(\" <span style=\"color: #ff0000;\">1:8<\/span> \").AutoFit\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-34594 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cw1.jpg\" alt=\"\" width=\"527\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa tinggi setiap baris telah disesuaikan secara otomatis setinggi yang diperlukan untuk menampilkan teks tertinggi di setiap baris:<\/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> <a href=\"https:\/\/statorials.org\/id\/vba-menemukan-baris-terakhir\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menemukan baris yang terakhir digunakan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menyisipkan-baris-dengan-pemformatan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menyisipkan baris dengan format<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-baris-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah baris dalam jangkauan<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk mengubah tinggi baris di Excel menggunakan VBA: Metode 1: Ubah tinggi baris SubChangeRowHeight () Rows(3).RowHeight = 40 End Sub Makro khusus ini mengubah ketinggian baris ketiga menjadi 40 . Catatan : Tinggi baris default di Excel adalah 14.4 . Metode 2: Ubah Ketinggian Beberapa Baris SubChangeRowHeight () Rows(&#8221; 1:5 [&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>Cara Mengubah Tinggi Baris di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah tinggi baris 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\/tinggi-garis-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengubah Tinggi Baris di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah tinggi baris menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tinggi-garis-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T07:12:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cw1.jpg\" \/>\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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tinggi-garis-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/tinggi-garis-vba\/\",\"name\":\"Cara Mengubah Tinggi Baris di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T07:12:37+00:00\",\"dateModified\":\"2023-07-11T07:12:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah tinggi baris menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tinggi-garis-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tinggi-garis-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tinggi-garis-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengubah tinggi baris di vba (dengan contoh)\"}]},{\"@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":"Cara Mengubah Tinggi Baris di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengubah tinggi baris 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\/tinggi-garis-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengubah Tinggi Baris di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengubah tinggi baris menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/tinggi-garis-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-11T07:12:37+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cw1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/tinggi-garis-vba\/","url":"https:\/\/statorials.org\/id\/tinggi-garis-vba\/","name":"Cara Mengubah Tinggi Baris di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T07:12:37+00:00","dateModified":"2023-07-11T07:12:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah tinggi baris menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tinggi-garis-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tinggi-garis-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tinggi-garis-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengubah tinggi baris di vba (dengan contoh)"}]},{"@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\/4414"}],"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=4414"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4414\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}