{"id":2122,"date":"2023-09-30T23:35:12","date_gmt":"2023-09-30T23:35:12","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/calcolare\/"},"modified":"2023-12-10T06:21:09","modified_gmt":"2023-12-10T06:21:09","slug":"calcolare","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/calcolare\/","title":{"rendered":"Come calcolare i valori delle celle in vba?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-1099069271\"><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>Per impostazione predefinita in Excel, ogni volta che si modifica il valore di una cella, Excel ricalcola tutte le celle che hanno una dipendenza di calcolo da quella cella. Ma quando usi VBA, hai la possibilit\u00e0 di cambiarlo in manuale, come facciamo in Excel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12581 \" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba.png\" alt=\"calcola-vba\" width=\"436\" height=\"301\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba.png 574w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba-300x207.png 300w\" sizes=\"auto, (max-width: 436px) 100vw, 436px\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Utilizzando il metodo di calcolo VBA<\/h2><p> \u00c8 possibile modificare il calcolo in manuale prima di avviare qualsiasi codice, come segue.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Application.Calculation = xlManual<\/code><\/pre><p> Quando esegui questo codice, il calcolo viene modificato in manuale. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12582 \" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/vba-calculate-method.png\" alt=\"metodo-calcola-vba\" width=\"466\" height=\"300\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/vba-calculate-method.png 577w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/vba-calculate-method-300x193.png 300w\" sizes=\"auto, (max-width: 466px) 100vw, 466px\"><\/figure><\/div><p> E alla fine del codice puoi utilizzare la seguente riga di codice per passare alla modalit\u00e0 automatica. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Application.Calculation = xlAutomatic<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-12585 \" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/passer-a-automatique-en-vba.png\" alt=\"passare ad automatico in vba\" width=\"473\" height=\"301\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/passer-a-automatique-en-vba.png 625w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/passer-a-automatique-en-vba-300x191.png 300w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\"><\/figure><\/div><p> \u00c8 possibile utilizzare il calcolo nel modo seguente. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61159\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-methode-de-calcul-code-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"Metodo di calcolo del codice vba\" width=\"419\" height=\"279\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub myMacro()    Application.Calculation = xlManual           'your code goes here       Application.Calculation = xlAutomatic End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Calcola ora (tutte le cartelle di lavoro aperte)<\/h2><p> Se desideri semplicemente ricalcolare tutte <a href=\"https:\/\/exceladvisor.org\/it\/schedario-aperto\/\">le cartelle di lavoro aperte<\/a> , puoi utilizzare il metodo &#8220;Calcola&#8221; come di seguito.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Calculate<\/code><\/pre><h2 class=\"wp-block-heading\"> Utilizzare il metodo di calcolo per un foglio<\/h2><p> Nel modo seguente \u00e8 possibile ricalcolare tutti i calcoli per tutti<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ActiveSheet.Calculate Sheets(\"Sheet1\").Calculate<\/code><\/pre><p> La prima riga di codice viene ricalcolata per il foglio attivo e la seconda riga lo fa per &#8220;Foglio1&#8221; ma puoi modificare il foglio se lo desideri.<\/p><h2 class=\"wp-block-heading\"> Calcola per un singolo intervallo o cella<\/h2><p> Allo stesso modo, puoi ricalcolare tutti i calcoli per un particolare intervallo o una singola cella come segue.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sheets(\"Sheet1\").Range(\"A1:A10\").Calculate Sheets(\"Sheet1\").Range(\"A1\").Calculate<\/code><\/pre><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\/it\/vba\/\">Cos&#8217;\u00e8 VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial correlati <\/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\/it\/media-2\/\">Valori medi in Excel con VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/data-odierna-ora-corrente\/\">Ottieni la data e l&#8217;ora attuali utilizzando VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/somma-1\/\">Somma i valori in Excel utilizzando VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/partita-2\/\">Funzione di corrispondenza in VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/modalita-1\/\">MOD in VBA<\/a><\/li><\/ul><\/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-2122","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>Come calcolare i valori delle celle in VBA?<\/title>\n<meta name=\"description\" content=\"In questo tutorial imparerai come utilizzare il metodo &quot;CALCULATE&quot; in VBA per modificare il calcolo del foglio di lavoro in manuale o\" \/>\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\/it\/calcolare\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Come calcolare i valori delle celle in VBA?\" \/>\n<meta property=\"og:description\" content=\"In questo tutorial imparerai come utilizzare il metodo &quot;CALCULATE&quot; in VBA per modificare il calcolo del foglio di lavoro in manuale o\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/calcolare\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:21:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo di lettura stimato\" \/>\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\/it\/calcolare\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/calcolare\/\",\"name\":\"Come calcolare i valori delle celle in VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/calcolare\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/calcolare\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba.png\",\"datePublished\":\"2023-09-30T23:35:12+00:00\",\"dateModified\":\"2023-12-10T06:21:09+00:00\",\"description\":\"In questo tutorial imparerai come utilizzare il metodo &quot;CALCULATE&quot; in VBA per modificare il calcolo del foglio di lavoro in manuale o\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/calcolare\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/calcolare\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/calcolare\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/calcolare\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come calcolare i valori delle celle in vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come calcolare i valori delle celle in VBA?","description":"In questo tutorial imparerai come utilizzare il metodo &quot;CALCULATE&quot; in VBA per modificare il calcolo del foglio di lavoro in manuale o","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\/it\/calcolare\/","og_locale":"it_IT","og_type":"article","og_title":"Come calcolare i valori delle celle in VBA?","og_description":"In questo tutorial imparerai come utilizzare il metodo &quot;CALCULATE&quot; in VBA per modificare il calcolo del foglio di lavoro in manuale o","og_url":"https:\/\/exceladvisor.org\/it\/calcolare\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:21:09+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/calcolare\/","url":"https:\/\/exceladvisor.org\/it\/calcolare\/","name":"Come calcolare i valori delle celle in VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/calcolare\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/calcolare\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba.png","datePublished":"2023-09-30T23:35:12+00:00","dateModified":"2023-12-10T06:21:09+00:00","description":"In questo tutorial imparerai come utilizzare il metodo &quot;CALCULATE&quot; in VBA per modificare il calcolo del foglio di lavoro in manuale o","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/calcolare\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/calcolare\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/calcolare\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/calculer-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/calcolare\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come calcolare i valori delle celle in vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=2122"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2122\/revisions"}],"predecessor-version":[{"id":2344,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/2122\/revisions\/2344"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=2122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}