{"id":1576,"date":"2023-11-16T11:52:53","date_gmt":"2023-11-16T11:52:53","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/numero-di-righe\/"},"modified":"2023-12-10T06:22:59","modified_gmt":"2023-12-10T06:22:59","slug":"numero-di-righe","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/numero-di-righe\/","title":{"rendered":"Come creare righe utilizzando vba in excel?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-534761762\"><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 contare le righe utilizzando VBA, \u00e8 necessario impostare l&#8217;intervallo da cui si desidera contare le righe, quindi utilizzare la propriet\u00e0 count and rows per ottenere il numero di righe da tale intervallo. Puoi anche utilizzare un ciclo per contare le righe in cui sono presenti solo dati.<\/p><h2 class=\"wp-block-heading\"> Usa VBA per contare le righe<\/h2><ol type=\"1\"><li> Innanzitutto, devi definire l&#8217;intervallo per il quale desideri contare le righe.<\/li><li> Successivamente, utilizza un punto (.) per aprire l&#8217;elenco di propriet\u00e0 e metodi.<\/li><li> Successivamente, digita o seleziona la propriet\u00e0 &#8220;Linee&#8221;.<\/li><li> Alla fine, utilizza la propriet\u00e0 \u201cCount\u201d. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58865\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-to-count-rows\" width=\"422\" height=\"262\"><\/figure><\/div><p> Ora quando esegui questo codice restituir\u00e0 il numero di righe e per ottenere il numero puoi utilizzare una <a href=\"https:\/\/exceladvisor.org\/it\/casella-msg-vba\/\">finestra di messaggio<\/a> o <a href=\"https:\/\/exceladvisor.org\/it\/valore-della-cella\/\">inserire direttamente questo valore anche in una cella<\/a> .<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_count_rows() Range(\"A1:A10\").Rows.Count End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Contare le righe per l&#8217;intervallo utilizzato<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_count_rows2()   MsgBox Worksheets(\"Sheet1\").UsedRange.Rows.Count End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Contare le righe con dati utilizzando VBA<\/h2><p> Puoi anche contare le righe contenenti dati ignorando le righe vuote. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-58866\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-lignes-de-comptage-avec-des-donnees-a-laide-de-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"conta-righe-con-dati-usando-vba\" width=\"627\" height=\"421\"><\/figure><\/div><p> Il codice seguente prender\u00e0 l&#8217;intervallo utilizzato come intervallo da ripetere e esaminer\u00e0 ogni riga una per una e controller\u00e0 se c&#8217;\u00e8 una cella non vuota l\u00ec, e se \u00e8 l\u00ec la considerer\u00e0 come una riga con dati, e in alla fine mostra una finestra di messaggio con il numero totale di righe.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_count_rows_with_data() Dim counter As Long Dim iRange As Range With ActiveSheet.UsedRange    'loop through each row from the used range    For Each iRange In .Rows        'check if the row contains a cell with a value        If Application.CountA(iRange) &gt; 0 Then            'counts the number of rows non-empty Cells            counter = counter + 1        End If    Next End With MsgBox \"Number of used rows is \" &amp; counter End Sub<\/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\/carattere-del-carattere\/\">Carattere VBA Excel (colore, dimensione, tipo e grassetto)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/nascondi-mostra-la-riga-della-colonna\/\">Excel VBA Nascondi e mostra una colonna o una riga<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/gamma-1\/\">Intervallo VBA di Excel: utilizzo di intervalli e celle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/frontiere\/\">Applica i bordi a una cella utilizzando VBA in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/trova-la-cella-della-colonna-dellultima-riga\/\">Trova l&#8217;ultima riga, colonna e cella utilizzando VBA in Excel<\/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-1576","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>\u25b7 Come creare righe utilizzando VBA in Excel?<\/title>\n<meta name=\"description\" content=\"In questo tutorial imparerai come utilizzare VBA per contare il numero di righe in Excel da un intervallo di celle, a\" \/>\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\/numero-di-righe\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Come creare righe utilizzando VBA in Excel?\" \/>\n<meta property=\"og:description\" content=\"In questo tutorial imparerai come utilizzare VBA per contare il numero di righe in Excel da un intervallo di celle, a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/numero-di-righe\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:22:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.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=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/numero-di-righe\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/numero-di-righe\/\",\"name\":\"\u25b7 Come creare righe utilizzando VBA in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/numero-di-righe\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/numero-di-righe\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png\",\"datePublished\":\"2023-11-16T11:52:53+00:00\",\"dateModified\":\"2023-12-10T06:22:59+00:00\",\"description\":\"In questo tutorial imparerai come utilizzare VBA per contare il numero di righe in Excel da un intervallo di celle, a\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/numero-di-righe\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/numero-di-righe\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/numero-di-righe\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/numero-di-righe\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come creare righe utilizzando vba in excel?\"}]},{\"@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":"\u25b7 Come creare righe utilizzando VBA in Excel?","description":"In questo tutorial imparerai come utilizzare VBA per contare il numero di righe in Excel da un intervallo di celle, a","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\/numero-di-righe\/","og_locale":"it_IT","og_type":"article","og_title":"\u25b7 Come creare righe utilizzando VBA in Excel?","og_description":"In questo tutorial imparerai come utilizzare VBA per contare il numero di righe in Excel da un intervallo di celle, a","og_url":"https:\/\/exceladvisor.org\/it\/numero-di-righe\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:22:59+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/numero-di-righe\/","url":"https:\/\/exceladvisor.org\/it\/numero-di-righe\/","name":"\u25b7 Come creare righe utilizzando VBA in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/numero-di-righe\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/numero-di-righe\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png","datePublished":"2023-11-16T11:52:53+00:00","dateModified":"2023-12-10T06:22:59+00:00","description":"In questo tutorial imparerai come utilizzare VBA per contare il numero di righe in Excel da un intervallo di celle, a","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/numero-di-righe\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/numero-di-righe\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/numero-di-righe\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-vba-pour-compter-les-lignes.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/numero-di-righe\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come creare righe utilizzando vba in excel?"}]},{"@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\/1576","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=1576"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1576\/revisions"}],"predecessor-version":[{"id":2466,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1576\/revisions\/2466"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=1576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}