{"id":1776,"date":"2023-11-05T12:20:57","date_gmt":"2023-11-05T12:20:57","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/"},"modified":"2023-12-10T06:06:29","modified_gmt":"2023-12-10T06:06:29","slug":"yapraklari-say","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/","title":{"rendered":"Vba kullanarak sayfalar nas\u0131l count edilir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3382631161\"><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>Excel&#8217;de \u00e7ok say\u0131da sayfan\u0131z varsa bunlar\u0131 manuel olarak saymak veya herhangi bir form\u00fcl kullanmak yerine VBA kodunu kullanarak bunlar\u0131 h\u0131zl\u0131 bir \u015fekilde sayabilirsiniz. Yani makalede bir \u00e7al\u0131\u015fma kitab\u0131n\u0131n sayfalar\u0131n\u0131 sayman\u0131n farkl\u0131 yollar\u0131n\u0131 g\u00f6rece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> Etkin \u00e7al\u0131\u015fma kitab\u0131ndaki sayfalar\u0131 sayma<\/h2><p> Aktif \u00e7al\u0131\u015fma kitab\u0131 sayfas\u0131n\u0131 saymak i\u00e7in kullanman\u0131z gereken kod a\u015fa\u011f\u0131dad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52417\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\" sizes=\"auto, \" srcset=\"\" alt=\"aktif-ciltleyiciden-sayfa-sayma-formu\" width=\"675\" height=\"344\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ThisWorkbook.Sheets.Count<\/code><\/pre><p> Bu kodda \u00f6ncelikle &#8220;ThisWorkbook&#8221; kullanarak aktif \u00e7al\u0131\u015fma kitab\u0131na ba\u015fvurdunuz ve t\u00fcm sayfalara ba\u015fvurdunuz, son olarak t\u00fcm sayfalar\u0131 saymak i\u00e7in count y\u00f6ntemini kulland\u0131n\u0131z. Sayfalar yerine \u00e7al\u0131\u015fma sayfalar\u0131n\u0131 saymak istiyorsan\u0131z a\u015fa\u011f\u0131daki kodu kullan\u0131n.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ThisWorkbook.Worksheets.Count<\/code><\/pre><p class=\"content-box-grey\"> <em>Yararl\u0131 ba\u011flant\u0131lar: <a href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">Makro \u00e7al\u0131\u015ft\u0131rma<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\">Makro kaydedici<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\">Visual Basic D\u00fczenleyici<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\">Ki\u015fisel Makrolar El Kitab\u0131<\/a><\/em><\/p><h2 class=\"wp-block-heading\"> Ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131ndaki sayfalar\u0131 say\u0131n<\/h2><p> \u00c7al\u0131\u015fma kitab\u0131na ba\u015fvurmak i\u00e7in ad\u0131n\u0131 kullanabilir ve ard\u0131ndan i\u00e7indeki sayfalar\u0131 sayabilirsiniz. Diyelim ki \u201cKitap1\u201d \u00e7al\u0131\u015fma kitab\u0131ndaki sayfalar\u0131 saymak istiyorsunuz.<\/p><p> \u0130\u015fte kod.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"sample-file.xlsx\").Sheets.Count<\/code><\/pre><p> Bu kod size \u201csample-file.xlsx\u201d \u00e7al\u0131\u015fma kitab\u0131ndaki sayfa say\u0131s\u0131n\u0131 verir. Bu klas\u00f6r\u00fcn al\u0131nmas\u0131 gereken bir \u015fey var, a\u00e7\u0131k olmas\u0131 gerekiyor.<\/p><h2 class=\"wp-block-heading\"> T\u00fcm a\u00e7\u0131k ciltlerin sayfalar\u0131n\u0131 say\u0131n<\/h2><p> Ayn\u0131 anda birden fazla \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7\u0131k tutabilir ve t\u00fcm bu \u00e7al\u0131\u015fma kitaplar\u0131ndaki sayfalar\u0131 sayabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_loop_all_sheets() Dim wb As Workbook Dim i As Long For Each wb In Application.Workbooks If wb.Name &lt;&gt; \"PERSONAL.XLSB\" Then i = i + wb.Sheets.Count End If Next wb MsgBox \"Total sheets in all the open workbooks: \" &amp; i End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Kapal\u0131 bir dosyan\u0131n sayfalar\u0131n\u0131 saymak<\/h2><p> Art\u0131k sistem masa\u00fcst\u00fcmde kay\u0131tl\u0131 \u00e7al\u0131\u015fma kitab\u0131na at\u0131fta bulunan baz\u0131 kodlar\u0131m\u0131z var. Bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131mda arkadaki bu \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7\u0131yor ve i\u00e7indeki sayfalar\u0131 say\u0131yor, sonra bu say\u0131m\u0131 A1 h\u00fccresine ekliyor.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_count_sheets() Dim wb As Workbook Application.DisplayAlerts = False Set wb = Workbooks.Open(\"C:UsersDellDesktopsample-file.xlsx\") ThisWorkbook.Sheets(1).Range(\"A1\").Value _ = wb.Sheets.Count wb.Close SaveChanges:=True Application.DisplayAlerts = True End Sub<\/code><\/pre><p> Dosyan\u0131n arka u\u00e7ta a\u00e7\u0131lmas\u0131 ve kapat\u0131lmas\u0131na ili\u015fkin ekran uyar\u0131lar\u0131n\u0131 devre d\u0131\u015f\u0131 b\u0131rakt\u0131k.<\/p><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\/temiz-sayfa\/\">Excel&#8217;de VBA kullanarak bir sayfan\u0131n tamam\u0131n\u0131 TEM\u0130ZLEY\u0130N<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-kopyala\/\">VBA&#8217;y\u0131 kullanarak Excel&#8217;de bir sayfay\u0131 kopyalay\u0131n ve ta\u015f\u0131y\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-sayfayi-sil-1\/\">Excel&#8217;de VBA kullanarak bir SAYFAYI S\u0130L\u0130N<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-gizle\/\">Excel&#8217;de VBA kullanarak bir sayfay\u0131 gizleme ve g\u00f6sterme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yapragi-korumak\/\">Excel&#8217;de VBA kullanarak bir sayfay\u0131 KORUMA ve KORUMADAN KALDIRMA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-yeniden-adlandir\/\">Excel&#8217;de VBA kullanarak bir sayfay\u0131 YEN\u0130DEN ADLANDIRIN<\/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-1776","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>Excel&#039;de VBA kullanarak sayfalar\u0131 COUNT nas\u0131l yap\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, VBA kullanarak Excel&#039;de sayfa sayman\u0131n farkl\u0131 yollar\u0131n\u0131 bulabileceksiniz.\" \/>\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\/yapraklari-say\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de VBA kullanarak sayfalar\u0131 COUNT nas\u0131l yap\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, VBA kullanarak Excel&#039;de sayfa sayman\u0131n farkl\u0131 yollar\u0131n\u0131 bulabileceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:06:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.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\/yapraklari-say\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/\",\"name\":\"Excel&#39;de VBA kullanarak sayfalar\u0131 COUNT nas\u0131l yap\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\",\"datePublished\":\"2023-11-05T12:20:57+00:00\",\"dateModified\":\"2023-12-10T06:06:29+00:00\",\"description\":\"Bu e\u011fitimde, VBA kullanarak Excel&#39;de sayfa sayman\u0131n farkl\u0131 yollar\u0131n\u0131 bulabileceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba kullanarak sayfalar nas\u0131l count edilir?\"}]},{\"@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":"Excel&#39;de VBA kullanarak sayfalar\u0131 COUNT nas\u0131l yap\u0131l\u0131r?","description":"Bu e\u011fitimde, VBA kullanarak Excel&#39;de sayfa sayman\u0131n farkl\u0131 yollar\u0131n\u0131 bulabileceksiniz.","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\/yapraklari-say\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de VBA kullanarak sayfalar\u0131 COUNT nas\u0131l yap\u0131l\u0131r?","og_description":"Bu e\u011fitimde, VBA kullanarak Excel&#39;de sayfa sayman\u0131n farkl\u0131 yollar\u0131n\u0131 bulabileceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:06:29+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.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\/yapraklari-say\/","url":"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/","name":"Excel&#39;de VBA kullanarak sayfalar\u0131 COUNT nas\u0131l yap\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png","datePublished":"2023-11-05T12:20:57+00:00","dateModified":"2023-12-10T06:06:29+00:00","description":"Bu e\u011fitimde, VBA kullanarak Excel&#39;de sayfa sayman\u0131n farkl\u0131 yollar\u0131n\u0131 bulabileceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/yapraklari-say\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-feuilles-de-comptage-forment-le-classeur-actif.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba kullanarak sayfalar nas\u0131l count edilir?"}]},{"@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\/1776","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=1776"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1776\/revisions"}],"predecessor-version":[{"id":2873,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1776\/revisions\/2873"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}