{"id":1576,"date":"2023-11-16T11:52:53","date_gmt":"2023-11-16T11:52:53","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/"},"modified":"2023-12-10T06:02:57","modified_gmt":"2023-12-10T06:02:57","slug":"satir-sayisi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/","title":{"rendered":"Excel&#39;de vba kullanarak sat\u0131rlar nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3812042565\"><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>VBA&#8217;y\u0131 kullanarak sat\u0131rlar\u0131 saymak i\u00e7in, sat\u0131rlar\u0131 saymak istedi\u011finiz aral\u0131\u011f\u0131 ayarlaman\u0131z, ard\u0131ndan bu aral\u0131ktaki sat\u0131r say\u0131s\u0131n\u0131 almak i\u00e7in count and row \u00f6zelli\u011fini kullanman\u0131z gerekir. Yaln\u0131zca veriye sahip oldu\u011funuz sat\u0131rlar\u0131 saymak i\u00e7in bir d\u00f6ng\u00fc de kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Sat\u0131rlar\u0131 saymak i\u00e7in VBA&#8217;y\u0131 kullan\u0131n<\/h2><ol type=\"1\"><li> \u00d6ncelikle sat\u0131r saymak istedi\u011finiz aral\u0131\u011f\u0131 tan\u0131mlaman\u0131z gerekir.<\/li><li> Bundan sonra, \u00f6zellikler ve y\u00f6ntemler listesini a\u00e7mak i\u00e7in nokta (.) kullan\u0131n.<\/li><li> Ard\u0131ndan \u201c\u00c7izgiler\u201d \u00f6zelli\u011fini yaz\u0131n veya se\u00e7in.<\/li><li> Sonunda \u201cCount\u201d \u00f6zelli\u011fini kullan\u0131n. <\/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-say\u0131lacak sat\u0131rlar\" width=\"422\" height=\"262\"><\/figure><\/div><p> Art\u0131k bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda sat\u0131r say\u0131s\u0131n\u0131 d\u00f6nd\u00fcrecektir ve say\u0131y\u0131 almak i\u00e7in bir <a href=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\">mesaj kutusu<\/a> kullanabilir veya <a href=\"https:\/\/exceladvisor.org\/tr\/hucre-degeri\/\">bu de\u011feri do\u011frudan bir h\u00fccreye girebilirsiniz<\/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\"> Kullan\u0131lan aral\u0131k i\u00e7in sat\u0131rlar\u0131 say<\/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\"> VBA kullanarak veri i\u00e7eren sat\u0131rlar\u0131 say\u0131n<\/h2><p> Bo\u015f sat\u0131rlar\u0131 yok sayarken veri i\u00e7eren sat\u0131rlar\u0131 da sayabilirsiniz. <\/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=\"vba-kullanarak-veri-ile-sat\u0131rlar\u0131 say\" width=\"627\" height=\"421\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki kod, kullan\u0131lan aral\u0131\u011f\u0131 d\u00f6ng\u00fc aral\u0131\u011f\u0131 olarak alacak ve her sat\u0131r\u0131 tek tek inceleyerek orada bo\u015f olmayan bir h\u00fccre olup olmad\u0131\u011f\u0131n\u0131 kontrol edecek ve e\u011fer oradaysa, onu veri i\u00e7eren bir sat\u0131r olarak de\u011ferlendirecek ve sonunda toplam sat\u0131r say\u0131s\u0131n\u0131 i\u00e7eren bir mesaj kutusu g\u00f6sterilir.<\/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\/tr\/vba\/\">VBA nedir<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/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\/tr\/karakter-yazi-tipi\/\">Excel VBA yaz\u0131 tipi (renk, boyut, t\u00fcr ve kal\u0131n)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sutun-satirini-gosteri-gizle\/\">Excel VBA Bir s\u00fctunu veya sat\u0131r\u0131 gizleyin ve g\u00f6sterin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aralik-1\/\">Excel VBA Aral\u0131\u011f\u0131 \u2013 Aral\u0131k ve H\u00fccrelerle \u00c7al\u0131\u015fmak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sinirlar\/\">Excel&#8217;de VBA kullanarak h\u00fccreye kenarl\u0131klar uygulama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/son-satirin-sutununun-hucresini-bulun\/\">Excel&#8217;de VBA Kullanarak Son Sat\u0131r\u0131, S\u00fctunu ve H\u00fccreyi Bulma<\/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 Excel&#039;de VBA kullanarak sat\u0131rlar nas\u0131l olu\u015fturulur?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;deki bir h\u00fccre aral\u0131\u011f\u0131ndaki sat\u0131r say\u0131s\u0131n\u0131 saymak i\u00e7in VBA&#039;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\" \/>\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\/tr\/satir-sayisi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de VBA kullanarak sat\u0131rlar nas\u0131l olu\u015fturulur?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;deki bir h\u00fccre aral\u0131\u011f\u0131ndaki sat\u0131r say\u0131s\u0131n\u0131 saymak i\u00e7in VBA&#039;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:02:57+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=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/\",\"name\":\"\u25b7 Excel&#39;de VBA kullanarak sat\u0131rlar nas\u0131l olu\u015fturulur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/#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:02:57+00:00\",\"description\":\"Bu e\u011fitimde, Excel&#39;deki bir h\u00fccre aral\u0131\u011f\u0131ndaki sat\u0131r say\u0131s\u0131n\u0131 saymak i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/#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\/tr\/satir-sayisi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de vba kullanarak sat\u0131rlar nas\u0131l olu\u015fturulur?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Excel&#39;de VBA kullanarak sat\u0131rlar nas\u0131l olu\u015fturulur?","description":"Bu e\u011fitimde, Excel&#39;deki bir h\u00fccre aral\u0131\u011f\u0131ndaki sat\u0131r say\u0131s\u0131n\u0131 saymak i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","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\/tr\/satir-sayisi\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de VBA kullanarak sat\u0131rlar nas\u0131l olu\u015fturulur?","og_description":"Bu e\u011fitimde, Excel&#39;deki bir h\u00fccre aral\u0131\u011f\u0131ndaki sat\u0131r say\u0131s\u0131n\u0131 saymak i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:02:57+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":{"Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/","url":"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/","name":"\u25b7 Excel&#39;de VBA kullanarak sat\u0131rlar nas\u0131l olu\u015fturulur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/#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:02:57+00:00","description":"Bu e\u011fitimde, Excel&#39;deki bir h\u00fccre aral\u0131\u011f\u0131ndaki sat\u0131r say\u0131s\u0131n\u0131 saymak i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/satir-sayisi\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/#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\/tr\/satir-sayisi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de vba kullanarak sat\u0131rlar nas\u0131l olu\u015fturulur?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1576"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1576\/revisions"}],"predecessor-version":[{"id":2626,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1576\/revisions\/2626"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}