{"id":4413,"date":"2023-07-11T07:30:16","date_gmt":"2023-07-11T07:30:16","guid":{"rendered":"https:\/\/statorials.org\/id\/lebar-kolom-vba\/"},"modified":"2023-07-11T07:30:16","modified_gmt":"2023-07-11T07:30:16","slug":"lebar-kolom-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/lebar-kolom-vba\/","title":{"rendered":"Cara mengubah lebar kolom di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan metode berikut untuk mengubah lebar kolom di Excel menggunakan VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Ubah lebar kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeColumnWidth<\/span> ()\nColumns(\" <span style=\"color: #ff0000;\">B<\/span> \").ColumnWidth = 20\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini mengubah lebar kolom B menjadi <strong>20<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Lebar kolom default di Excel adalah <strong>8.29<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Ubah Lebar Beberapa Kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeColumnWidth<\/span> ()\nColumns(\" <span style=\"color: #ff0000;\">B:D<\/span> \").ColumnWidth = 20\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini mengubah lebar semua kolom dalam rentang dari B ke D hingga <strong>20<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Secara otomatis menyesuaikan lebar beberapa kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeColumnWidth<\/span> ()\nColumns(\" <span style=\"color: #ff0000;\">B:D<\/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 lebar setiap kolom dalam rentang B hingga D menjadi selebar yang diperlukan untuk menampilkan sel terpanjang di setiap kolom.<\/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<h2> <span style=\"color: #000000;\"><strong>Contoh 1: mengubah lebar kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk mengubah lebar kolom B menjadi 20:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeColumnWidth<\/span> ()\nColumns(\" <span style=\"color: #ff0000;\">B<\/span> \").ColumnWidth = 20\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-34595 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cw2.jpg\" alt=\"\" width=\"548\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya lebar kolom B (kolom &#8220;Titik&#8221;) yang diubah menjadi 20 sedangkan lebar kolom lainnya tetap sama.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Mengubah lebar beberapa kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk mengubah lebar kolom B ke D menjadi 20:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeColumnWidth<\/span> ()\nColumns(\" <span style=\"color: #ff0000;\">B:D<\/span> \").ColumnWidth = 20\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-34596 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cw3.jpg\" alt=\"\" width=\"657\" height=\"433\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa lebar setiap kolom dari B ke D diubah menjadi 20 sedangkan lebar kolom A tetap sama.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Secara otomatis menyesuaikan lebar beberapa kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk secara otomatis mengatur lebar setiap kolom dari A hingga D sehingga selebar yang diperlukan untuk menampilkan sel terpanjang di setiap kolom.<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubChangeColumnWidth<\/span> ()\nColumns(\" <span style=\"color: #ff0000;\">A:D<\/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-34597 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cw4.jpg\" alt=\"\" width=\"485\" height=\"418\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa lebar setiap kolom telah disesuaikan secara otomatis menjadi selebar yang diperlukan untuk menampilkan sel terpanjang di setiap kolom.<\/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\/jumlah-kolom-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung jumlah kolom yang digunakan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-temukan-kolom-terakhir\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menemukan kolom yang terakhir digunakan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/hapus-kolom-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: cara menghapus kolom<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan metode berikut untuk mengubah lebar kolom di Excel menggunakan VBA: Metode 1: Ubah lebar kolom SubChangeColumnWidth () Columns(&#8221; B &#8220;).ColumnWidth = 20 End Sub Makro khusus ini mengubah lebar kolom B menjadi 20 . Catatan : Lebar kolom default di Excel adalah 8.29 . Metode 2: Ubah Lebar Beberapa Kolom SubChangeColumnWidth () [&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 Lebar Kolom di VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah lebar kolom di 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\/lebar-kolom-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengubah Lebar Kolom di VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah lebar kolom di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/lebar-kolom-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T07:30:16+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\/lebar-kolom-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/lebar-kolom-vba\/\",\"name\":\"Cara Mengubah Lebar Kolom di VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T07:30:16+00:00\",\"dateModified\":\"2023-07-11T07:30:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah lebar kolom di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/lebar-kolom-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/lebar-kolom-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/lebar-kolom-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengubah lebar kolom 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 Lebar Kolom di VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengubah lebar kolom di 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\/lebar-kolom-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengubah Lebar Kolom di VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengubah lebar kolom di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/lebar-kolom-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-11T07:30:16+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\/lebar-kolom-vba\/","url":"https:\/\/statorials.org\/id\/lebar-kolom-vba\/","name":"Cara Mengubah Lebar Kolom di VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T07:30:16+00:00","dateModified":"2023-07-11T07:30:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah lebar kolom di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/lebar-kolom-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/lebar-kolom-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/lebar-kolom-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengubah lebar kolom 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\/4413"}],"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=4413"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4413\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}