{"id":1956,"date":"2023-10-26T12:11:59","date_gmt":"2023-10-26T12:11:59","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/cverr\/"},"modified":"2023-12-06T06:17:01","modified_gmt":"2023-12-06T06:17:01","slug":"cverr","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/cverr\/","title":{"rendered":"Bagaimana cara menggunakan fungsi vba cverr?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1177094060\"><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>Fungsi VBA CVERR tercantum dalam kategori penanganan kesalahan vba pada fungsi VBA. Saat Anda menggunakannya dalam kode VBA, <strong>ia mengembalikan tipe data kesalahan berdasarkan kode yang Anda tentukan<\/strong> . Sederhananya, dengan CVERR Anda bisa mendapatkan beberapa jenis kesalahan pada hasilnya. Lihat kode kesalahan ini <a href=\"https:\/\/www.vba-market.com\/list-of-vba-error-codes\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">dari sini<\/a> .<\/p><h2 class=\"wp-block-heading\"> Sintaksis<\/h2><p> <strong>CVERr (Ekspresi)<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumen<\/h2><ul><li> <strong>Ekspresi<\/strong> : Kode kesalahan yang ingin Anda ketahui tipe data kesalahannya.<\/li><\/ul><h2 class=\"wp-block-heading\"> Contoh<\/h2><p> Untuk memahami secara praktis cara menggunakan fungsi VBA CVERR, Anda perlu melihat contoh di bawah ini di mana kami telah menulis kode vba menggunakannya: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"contoh-vba-cveer-fungsi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-cveer-function\" width=\"786\" height=\"526\"><\/figure><\/div><p> Pada kode di atas, kita telah menggunakan CVERR dan kondisi IF untuk mengujinya, di mana ia memeriksa apakah nilai di sel A2 nol atau tidak, dan jika ya, kami telah memberikan kode ke error 11 (11 adalah errornya tipe data yang mewakili pembagian dengan nol) ke fungsi untuk mengembalikan tipe data kesalahan.<\/p><h2 class=\"wp-block-heading\"> Komentar<\/h2><ul><li> Jika argumen yang Anda tetapkan sebagai kode kesalahan bukan kode kesalahan dan selain angka, VBA akan mengembalikan kesalahan runtime 13.<\/li><li> Dan jika argumen yang Anda tetapkan adalah angka tetapi bukan kode kesalahan, VBA akan mengembalikan runtime error 5.<\/li><\/ul>","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-1956","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 menggunakan fungsi VBA CVERR? (Sintaks + Contoh)<\/title>\n<meta name=\"description\" content=\"Pelajari cara menggunakan fungsi VBA CVERR dengan sintaks, argumen, dan contoh dengan kode 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:\/\/exceladvisor.org\/id\/cverr\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan fungsi VBA CVERR? (Sintaks + Contoh)\" \/>\n<meta property=\"og:description\" content=\"Pelajari cara menggunakan fungsi VBA CVERR dengan sintaks, argumen, dan contoh dengan kode contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/cverr\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/cverr\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/cverr\/\",\"name\":\"Bagaimana cara menggunakan fungsi VBA CVERR? (Sintaks + Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/cverr\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/cverr\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png\",\"datePublished\":\"2023-10-26T12:11:59+00:00\",\"dateModified\":\"2023-12-06T06:17:01+00:00\",\"description\":\"Pelajari cara menggunakan fungsi VBA CVERR dengan sintaks, argumen, dan contoh dengan kode contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/cverr\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/cverr\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/cverr\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/cverr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan fungsi vba cverr?\"}]},{\"@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 menggunakan fungsi VBA CVERR? (Sintaks + Contoh)","description":"Pelajari cara menggunakan fungsi VBA CVERR dengan sintaks, argumen, dan contoh dengan kode 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:\/\/exceladvisor.org\/id\/cverr\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan fungsi VBA CVERR? (Sintaks + Contoh)","og_description":"Pelajari cara menggunakan fungsi VBA CVERR dengan sintaks, argumen, dan contoh dengan kode contoh.","og_url":"https:\/\/exceladvisor.org\/id\/cverr\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:01+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/cverr\/","url":"https:\/\/exceladvisor.org\/id\/cverr\/","name":"Bagaimana cara menggunakan fungsi VBA CVERR? (Sintaks + Contoh)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/cverr\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/cverr\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png","datePublished":"2023-10-26T12:11:59+00:00","dateModified":"2023-12-06T06:17:01+00:00","description":"Pelajari cara menggunakan fungsi VBA CVERR dengan sintaks, argumen, dan contoh dengan kode contoh.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/cverr\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/cverr\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/cverr\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-vba-cveer.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/cverr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan fungsi vba cverr?"}]},{"@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\/1956","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=1956"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1956\/revisions"}],"predecessor-version":[{"id":2571,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1956\/revisions\/2571"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}