{"id":4385,"date":"2023-07-11T12:38:41","date_gmt":"2023-07-11T12:38:41","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/"},"modified":"2023-07-11T12:38:41","modified_gmt":"2023-07-11T12:38:41","slug":"vba-menemukan-nilai-maksimal-dalam-jangkauan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/","title":{"rendered":"Vba: cara menemukan nilai maksimum dalam jangkauan"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menghitung nilai maksimum dalam suatu rentang menggunakan VBA:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubMaxValue<\/span> ()\n    Range(\" <span style=\"color: #ff0000;\">D2<\/span> \") = WorksheetFunction.Max(Range(\" <span style=\"color: #ff0000;\">B2:B11<\/span> \"))\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung nilai maksimum dalam rentang <strong>B2:B11<\/strong> dan menetapkan hasilnya ke sel <strong>D2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin menampilkan nilai maksimum dalam kotak pesan, Anda dapat menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubMaxValue<\/span> ()\n    <span style=\"color: #008000;\">'Create variable to store max value<\/span>\n    <span style=\"color: #0000ff;\">Dim<\/span> maxValue <span style=\"color: #0000ff;\">As<\/span> Single\n    \n    <span style=\"color: #008000;\">'Calculate max value in range<\/span>\n    maxValue = WorksheetFunction.Max(Range(\" <span style=\"color: #ff0000;\">B2:B11<\/span> \"))\n    \n    <span style=\"color: #008000;\">'Display the result<\/span>\n    MsgBox \" <span style=\"color: #ff0000;\">Max Value in Range:<\/span> \" &amp; maxValue \n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan masing-masing metode ini dalam praktik dengan himpunan data berikut di Excel yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34144 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plage-de-somme1.jpg\" alt=\"\" width=\"494\" height=\"423\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Hitung nilai maksimum rentang menggunakan VBA dan tampilkan hasilnya di sel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung nilai maksimum di kolom poin dan menampilkan hasilnya di sel tertentu.<\/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;\">SubMaxValue<\/span> ()\n    Range(\" <span style=\"color: #ff0000;\">D2<\/span> \") = WorksheetFunction.Max(Range(\" <span style=\"color: #ff0000;\">B2:B11<\/span> \"))\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-34408 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vm1.jpg\" alt=\"\" width=\"510\" height=\"411\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa sel <b>D2<\/b> berisi nilai <strong>43<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini memberitahu kita bahwa nilai maksimum pada kolom poin adalah 43.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Hitung nilai maksimum rentang menggunakan VBA dan tampilkan hasilnya di kotak pesan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin menghitung nilai maksimum di kolom poin dan menampilkan hasilnya di kotak pesan.<\/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;\">SubMaxValue<\/span> ()\n    <span style=\"color: #008000;\">'Create variable to store max value<\/span>\n    <span style=\"color: #0000ff;\">Dim<\/span> maxValue <span style=\"color: #0000ff;\">As<\/span> Single\n    \n    <span style=\"color: #008000;\">'Calculate max value in range<\/span>\n    maxValue = WorksheetFunction.Max(Range(\" <span style=\"color: #ff0000;\">B2:B11<\/span> \"))\n    \n    <span style=\"color: #008000;\">'Display the result<\/span>\n    MsgBox \" <span style=\"color: #ff0000;\">Max Value in Range:<\/span> \" &amp; maxValue \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=\"aligncenter wp-image-34409\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/machine-virtuelle-2.jpg\" alt=\"VBA menemukan nilai maksimum dalam jangkauan\" width=\"528\" height=\"451\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kotak pesan memberitahu kita bahwa nilai maksimum dalam rentang <strong>B2:B11<\/strong> adalah <strong>43<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kami menghitung nilai maksimum dalam rentang <strong>B2:B11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, jika Anda ingin menghitung nilai maksimum di seluruh kolom, Anda bisa mengetikkan <strong>B:B<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini akan menghitung nilai maksimum di semua kolom B.<\/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-jarak-menengah\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung nilai rata-rata rentang<\/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><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-jumlah-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menambahkan nilai dalam suatu rentang<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menghitung nilai maksimum dalam suatu rentang menggunakan VBA: SubMaxValue () Range(&#8221; D2 &#8220;) = WorksheetFunction.Max(Range(&#8221; B2:B11 &#8220;)) End Sub Contoh khusus ini menghitung nilai maksimum dalam rentang B2:B11 dan menetapkan hasilnya ke sel D2 . Jika Anda ingin menampilkan nilai maksimum dalam kotak pesan, Anda dapat menggunakan sintaks [&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 menemukan nilai maksimum dalam jangkauan \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mencari nilai maksimum dalam suatu rentang 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-menemukan-nilai-maksimal-dalam-jangkauan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menemukan nilai maksimum dalam jangkauan \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mencari nilai maksimum dalam suatu rentang menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T12:38:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plage-de-somme1.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\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/\",\"name\":\"VBA: Cara menemukan nilai maksimum dalam jangkauan \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T12:38:41+00:00\",\"dateModified\":\"2023-07-11T12:38:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mencari nilai maksimum dalam suatu rentang menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menemukan nilai maksimum dalam jangkauan\"}]},{\"@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 menemukan nilai maksimum dalam jangkauan \u2013 Statorial","description":"Tutorial ini menjelaskan cara mencari nilai maksimum dalam suatu rentang 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-menemukan-nilai-maksimal-dalam-jangkauan\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menemukan nilai maksimum dalam jangkauan \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara mencari nilai maksimum dalam suatu rentang menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/","og_site_name":"Statorials","article_published_time":"2023-07-11T12:38:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/plage-de-somme1.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\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/","url":"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/","name":"VBA: Cara menemukan nilai maksimum dalam jangkauan \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T12:38:41+00:00","dateModified":"2023-07-11T12:38:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mencari nilai maksimum dalam suatu rentang menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menemukan-nilai-maksimal-dalam-jangkauan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menemukan nilai maksimum dalam jangkauan"}]},{"@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\/4385"}],"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=4385"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4385\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4385"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}