{"id":2162,"date":"2023-09-27T16:45:34","date_gmt":"2023-09-27T16:45:34","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/"},"modified":"2023-12-06T06:14:50","modified_gmt":"2023-12-06T06:14:50","slug":"kesalahan-ketidakcocokan-tipe-13","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/","title":{"rendered":"Bagaimana cara memperbaiki kesalahan vba 13?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1024877948\"><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>Ketidakcocokan tipe (kesalahan 13) terjadi saat Anda mencoba menentukan nilai ke variabel yang tidak cocok dengan tipe datanya. Di VBA, saat Anda mendeklarasikan variabel, Anda perlu menyetel tipe datanya, dan saat Anda menentukan nilai selain tipe data tersebut, Anda mendapatkan kesalahan ketidakcocokan tipe 13. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57054\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dincompatibilite-de-type.png\" sizes=\"auto, \" srcset=\"\" alt=\"kesalahan ketik tidak cocok\" width=\"414\" height=\"234\"><\/figure><\/div><p> Dalam tutorial ini, kita akan melihat kemungkinan situasi di mana kesalahan runtime 13 dapat terjadi saat mengeksekusi kode.<\/p><h2 class=\"wp-block-heading\"> Kesalahan ketidakcocokan jenis tanggal<\/h2><p> Di VBA terdapat tipe data khusus untuk menangani tanggal dan terkadang hal ini terjadi ketika Anda menggunakan variabel untuk menyimpan tanggal dan nilai yang Anda tentukan berbeda.<\/p><p> Dalam kode berikut saya mendeklarasikan variabel sebagai tanggal dan kemudian menentukan nilai sel A1 di mana saya seharusnya hanya memiliki tanggal. Namun seperti yang Anda lihat, tanggal yang saya miliki di sel 1 tidak dalam format yang benar, VBA tidak dapat mengidentifikasinya sebagai tanggal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57055\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-erreur-de-non-concordance-de-type-avec-la-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"746\" height=\"377\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() Dim iVal As Date iVal = Range(\"A1\").Value End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Kesalahan ketik tidak cocok dengan angka<\/h2><p> Anda akan mendapatkan kesalahan yang sama ketika berhadapan dengan angka di mana Anda mendapatkan nilai berbeda saat Anda mencoba menentukan angka ke variabel.<\/p><p> Dalam contoh berikut, Anda memiliki kesalahan di sel A1 yang seharusnya berupa nilai numerik. Jadi ketika Anda menjalankan kode, VBA menunjukkan runtime error 13 karena tidak dapat mengidentifikasi nilai sebagai angka. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57056\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-erreur-de-non-concordance-de-type-avec-le-numero.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"751\" height=\"477\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro() Dim iNum As Long iNum = Range(\"A6\").Value End Sub<\/code><\/pre><h3 class=\"wp-block-heading\"> <strong>Kesalahan runtime 6 Meluap<\/strong><\/h3><p> Di VBA, ada beberapa tipe data untuk menangani angka dan masing-masing tipe data ini memiliki rentang angka yang dapat Anda tetapkan padanya. Namun ada masalah saat Anda menentukan angka di luar rentang tipe data.<\/p><p> Dalam hal ini, kami akan menunjukkan kepada Anda runtime error 6 overflow yang menunjukkan bahwa Anda perlu mengubah tipe data dan nomor yang Anda tentukan di luar jangkauan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57057\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-erreur-dexecution-6-debordement.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"722\" height=\"424\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Situasi lain di mana hal ini bisa terjadi<\/h2><p> Mungkin ada situasi lain di mana Anda mungkin menghadapi kesalahan runtime 14: Type Mismatch.<\/p><ol type=\"1\"><li> Saat Anda menetapkan rentang ke tabel tetapi rentang tersebut hanya terdiri dari satu sel.<\/li><li> Saat Anda mendefinisikan variabel sebagai objek, namun saat menulis kode, Anda menentukan objek yang berbeda dari variabel tersebut.<\/li><li> Saat Anda menentukan variabel sebagai lembar kerja tetapi menggunakan kumpulan lembar dalam kode atau sebaliknya.<\/li><\/ol><h2 class=\"wp-block-heading\"> Cara Memperbaiki Ketidakcocokan Jenis (Kesalahan 13)<\/h2><p> Cara terbaik untuk mengatasi kesalahan ini adalah dengan mengakses instruksi untuk mengeksekusi baris kode tertentu atau menampilkan kotak pesan kepada pengguna ketika kesalahan terjadi. Namun Anda juga bisa mengecek medan selangkah demi selangkah sebelum menjalankannya. Untuk melakukan ini, Anda perlu menggunakan alat debug VBA, atau Anda juga dapat menggunakan tombol pintas F8. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57058\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-comment-corriger-lincompatibilite-de-type.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"586\" height=\"387\"><\/figure><\/div><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\/penanganan-kesalahan\/\">Penanganan kesalahan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-otomatisasi-440\/\">Kesalahan otomatisasi VBA (Kesalahan 440)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/panggilan-prosedur-tidak-valid-atau-kesalahan-argumen-5\/\">Panggilan prosedur VBA atau kesalahan argumen tidak valid (Kesalahan 5)<\/a><\/li><li><a href=\"https:\/\/exceladvisor.org\/id\/objek-tidak-mendukung-properti-atau-metode-ini-kesalahan-438\/\">Objek VBA tidak mendukung kesalahan properti atau metode ini (Kesalahan 438)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/\">Kesalahan yang Diperlukan Objek VBA (Kesalahan 424)<\/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-2162","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 memperbaiki kesalahan ketidakcocokan VBA (Kesalahan 13)?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini Anda akan mempelajari mengapa ketidakcocokan tipe (kesalahan 13) terjadi dan cara mengatasinya saat menulis\" \/>\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\/kesalahan-ketidakcocokan-tipe-13\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara memperbaiki kesalahan ketidakcocokan VBA (Kesalahan 13)?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini Anda akan mempelajari mengapa ketidakcocokan tipe (kesalahan 13) terjadi dan cara mengatasinya saat menulis\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dincompatibilite-de-type.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/\",\"name\":\"Bagaimana cara memperbaiki kesalahan ketidakcocokan VBA (Kesalahan 13)?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dincompatibilite-de-type.png\",\"datePublished\":\"2023-09-27T16:45:34+00:00\",\"dateModified\":\"2023-12-06T06:14:50+00:00\",\"description\":\"Dalam tutorial ini Anda akan mempelajari mengapa ketidakcocokan tipe (kesalahan 13) terjadi dan cara mengatasinya saat menulis\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dincompatibilite-de-type.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dincompatibilite-de-type.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memperbaiki kesalahan vba 13?\"}]},{\"@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 memperbaiki kesalahan ketidakcocokan VBA (Kesalahan 13)?","description":"Dalam tutorial ini Anda akan mempelajari mengapa ketidakcocokan tipe (kesalahan 13) terjadi dan cara mengatasinya saat menulis","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\/kesalahan-ketidakcocokan-tipe-13\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memperbaiki kesalahan ketidakcocokan VBA (Kesalahan 13)?","og_description":"Dalam tutorial ini Anda akan mempelajari mengapa ketidakcocokan tipe (kesalahan 13) terjadi dan cara mengatasinya saat menulis","og_url":"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dincompatibilite-de-type.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/","url":"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/","name":"Bagaimana cara memperbaiki kesalahan ketidakcocokan VBA (Kesalahan 13)?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dincompatibilite-de-type.png","datePublished":"2023-09-27T16:45:34+00:00","dateModified":"2023-12-06T06:14:50+00:00","description":"Dalam tutorial ini Anda akan mempelajari mengapa ketidakcocokan tipe (kesalahan 13) terjadi dan cara mengatasinya saat menulis","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dincompatibilite-de-type.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dincompatibilite-de-type.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/kesalahan-ketidakcocokan-tipe-13\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memperbaiki kesalahan vba 13?"}]},{"@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\/2162","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=2162"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2162\/revisions"}],"predecessor-version":[{"id":2374,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2162\/revisions\/2374"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}