{"id":482,"date":"2023-10-26T12:11:59","date_gmt":"2023-10-26T12:11:59","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/cubrir\/"},"modified":"2023-12-25T10:30:15","modified_gmt":"2023-12-25T10:30:15","slug":"cubrir","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/cubrir\/","title":{"rendered":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba cverr?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3889946334\"><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>La funci\u00f3n VBA CVERR aparece en la categor\u00eda de manejo de errores de VBA de funciones VBA. Cuando lo usa en c\u00f3digo VBA, <strong>devuelve un tipo de datos de error basado en el c\u00f3digo que especifica<\/strong> . En t\u00e9rminos simples, con CVERR puedes obtener alg\u00fan tipo de error en el resultado. Consulte estos c\u00f3digos de error <a href=\"https:\/\/www.vba-market.com\/list-of-vba-error-codes\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">desde aqu\u00ed<\/a> .<\/p>\n<h2 class=\"wp-block-heading\"> Sintaxis<\/h2>\n<p> <strong>CVErr(Expresi\u00f3n)<\/strong><\/p>\n<h2 class=\"wp-block-heading\"> Argumentos<\/h2>\n<ul>\n<li> <strong>Expresi\u00f3n<\/strong> : C\u00f3digo de error del que desea conocer el tipo de datos de error.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Ejemplo<\/h2>\n<p> Para comprender pr\u00e1cticamente c\u00f3mo usar la funci\u00f3n VBA CVERR, debe seguir el siguiente ejemplo donde escribimos un c\u00f3digo vba us\u00e1ndola: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"ejemplo-vba-cveer-funci\u00f3n\" 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>\n<\/div>\n<p> En el c\u00f3digo anterior, hemos utilizado CVERR y la condici\u00f3n IF con \u00e9l para realizar la prueba, donde verifica si el valor en la celda A2 es cero o no, y si lo es, hemos proporcionado el c\u00f3digo del error 11 (11 es el error tipo de datos que representa la divisi\u00f3n por cero) a la funci\u00f3n para devolver el tipo de datos de error.<\/p>\n<h2 class=\"wp-block-heading\"> Comentarios<\/h2>\n<ul>\n<li> Si el argumento que estableci\u00f3 como c\u00f3digo de error no es un c\u00f3digo de error y no es un n\u00famero, VBA devolver\u00e1 el error de tiempo de ejecuci\u00f3n 13.<\/li>\n<li> Y si el argumento que establece es un n\u00famero pero no un c\u00f3digo de error, VBA devolver\u00e1 un error de tiempo de ejecuci\u00f3n 5.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>La funci\u00f3n VBA CVERR aparece en la categor\u00eda de manejo de errores de VBA de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve un tipo de datos de error basado en el c\u00f3digo que especifica . En t\u00e9rminos simples, con CVERR puedes obtener alg\u00fan tipo de error en el resultado. Consulte estos c\u00f3digos de [&hellip;]<\/p>\n","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-482","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>\u00bfc\u00f3mo utilizar la funci\u00f3n vba cverr?<\/title>\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\/es\/cubrir\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba cverr?\" \/>\n<meta property=\"og:description\" content=\"La funci\u00f3n VBA CVERR aparece en la categor\u00eda de manejo de errores de VBA de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve un tipo de datos de error basado en el c\u00f3digo que especifica . En t\u00e9rminos simples, con CVERR puedes obtener alg\u00fan tipo de error en el resultado. Consulte estos c\u00f3digos de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/cubrir\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:30:15+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=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/cubrir\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/cubrir\/\",\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba cverr?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cubrir\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cubrir\/#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-25T10:30:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/cubrir\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/cubrir\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/cubrir\/#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\/es\/cubrir\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo utilizar la funci\u00f3n vba cverr?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba cverr?","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\/es\/cubrir\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba cverr?","og_description":"La funci\u00f3n VBA CVERR aparece en la categor\u00eda de manejo de errores de VBA de funciones VBA. Cuando lo usa en c\u00f3digo VBA, devuelve un tipo de datos de error basado en el c\u00f3digo que especifica . En t\u00e9rminos simples, con CVERR puedes obtener alg\u00fan tipo de error en el resultado. Consulte estos c\u00f3digos de [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/cubrir\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:30:15+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":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/cubrir\/","url":"https:\/\/exceladvisor.org\/es\/cubrir\/","name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba cverr?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/cubrir\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/cubrir\/#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-25T10:30:15+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/cubrir\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/cubrir\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/cubrir\/#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\/es\/cubrir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo utilizar la funci\u00f3n vba cverr?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=482"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/482\/revisions"}],"predecessor-version":[{"id":1243,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/482\/revisions\/1243"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}