{"id":4448,"date":"2023-07-11T01:22:18","date_gmt":"2023-07-11T01:22:18","guid":{"rendered":"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/"},"modified":"2023-07-11T01:22:18","modified_gmt":"2023-07-11T01:22:18","slug":"vba-filtreyi-temizle","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/","title":{"rendered":"Vba kullanarak excel&#39;de filtreler nas\u0131l temizlenir (\u00f6rnekle)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Bir Excel sayfas\u0131ndaki t\u00fcm filtreleri temizlemek i\u00e7in VBA&#8217;da a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubClearFilters<\/span> ()\n\n<span style=\"color: #0000ff;\">If<\/span> ActiveSheet.AutoFilterMode <span style=\"color: #0000ff;\">Then<\/span> ActiveSheet.ShowAllData\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Bu \u00f6zel makro, \u015fu anda etkin olan sayfadaki t\u00fcm filtreleri temizleyecektir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu makro, \u015fu anda gizli olan t\u00fcm sat\u0131rlar\u0131n g\u00f6r\u00fcn\u00fcr olmas\u0131n\u0131 sa\u011flamak i\u00e7in <strong>ShowAllData<\/strong> y\u00f6ntemini kullanarak \u00e7al\u0131\u015f\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Etkin sayfada \u015fu anda hi\u00e7bir sat\u0131r filtrelenmemi\u015fse, bu makroyu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda hi\u00e7bir \u015fey olmayacakt\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnekte bu makronun pratikte nas\u0131l kullan\u0131laca\u011f\u0131 g\u00f6sterilmektedir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: VBA Kullanarak Excel&#8217;deki T\u00fcm Filtreleri Temizleme<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Diyelim ki Excel&#8217;de \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgiler i\u00e7eren a\u015fa\u011f\u0131daki veri k\u00fcmesine sahibiz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34820 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cf1.png\" alt=\"\" width=\"515\" height=\"431\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u015eimdi, yaln\u0131zca Tak\u0131m s\u00fctunundaki de\u011ferin Mavs veya Nets&#8217;e e\u015fit oldu\u011fu sat\u0131rlar\u0131 g\u00f6sterecek bir filtre ekledi\u011fimizi varsayal\u0131m:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34821 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cf2.png\" alt=\"\" width=\"507\" height=\"399\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u015eimdi bu filtreyi VBA kullanarak temizlemek istedi\u011fimizi varsayal\u0131m.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunun i\u00e7in a\u015fa\u011f\u0131daki makroyu olu\u015fturabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubClearFilters<\/span> ()\n\n<span style=\"color: #0000ff;\">If<\/span> ActiveSheet.AutoFilterMode <span style=\"color: #0000ff;\">Then<\/span> ActiveSheet.ShowAllData\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Bu makroyu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda filtre sayfadan otomatik olarak temizlenecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34822 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cf3.png\" alt=\"\" width=\"521\" height=\"440\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Filtreyi temizledi\u011fimiz i\u00e7in daha \u00f6nce gizlenen t\u00fcm sat\u0131rlar\u0131n art\u0131k yeniden g\u00f6r\u00fcn\u00fcr oldu\u011funu unutmay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Not<\/strong> : VBA <strong>ShowAllData<\/strong> y\u00f6ntemine ili\u015fkin t\u00fcm belgeleri <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.worksheet.showalldata\" target=\"_blank\" rel=\"noopener\">burada<\/a> bulabilirsiniz.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde VBA&#8217;da di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/vba-filtre-pivot-tablosu\/\" target=\"_blank\" rel=\"noopener\">VBA: Pivot tablolar\u0131 filtreleme<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/vba-pivot-tabloyu-yenile\/\" target=\"_blank\" rel=\"noopener\">VBA: pivot tablolar\u0131 nas\u0131l yenilenir<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/vba-kopyalari-kaldir\/\" target=\"_blank\" rel=\"noopener\">VBA: yinelenen de\u011ferler nas\u0131l kald\u0131r\u0131l\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bir Excel sayfas\u0131ndaki t\u00fcm filtreleri temizlemek i\u00e7in VBA&#8217;da a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz: SubClearFilters () If ActiveSheet.AutoFilterMode Then ActiveSheet.ShowAllData End Sub Bu \u00f6zel makro, \u015fu anda etkin olan sayfadaki t\u00fcm filtreleri temizleyecektir. Bu makro, \u015fu anda gizli olan t\u00fcm sat\u0131rlar\u0131n g\u00f6r\u00fcn\u00fcr olmas\u0131n\u0131 sa\u011flamak i\u00e7in ShowAllData y\u00f6ntemini kullanarak \u00e7al\u0131\u015f\u0131r. Etkin sayfada \u015fu anda hi\u00e7bir sat\u0131r filtrelenmemi\u015fse, bu makroyu [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4448","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA Kullanarak Excel&#039;de Filtreler Nas\u0131l Temizlenir (\u00d6rnek ile) - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, VBA kullan\u0131larak bir \u00e7al\u0131\u015fma sayfas\u0131ndan filtrelerin nas\u0131l kald\u0131r\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA Kullanarak Excel&#039;de Filtreler Nas\u0131l Temizlenir (\u00d6rnek ile) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, VBA kullan\u0131larak bir \u00e7al\u0131\u015fma sayfas\u0131ndan filtrelerin nas\u0131l kald\u0131r\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T01:22:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cf1.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/\",\"url\":\"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/\",\"name\":\"VBA Kullanarak Excel&#39;de Filtreler Nas\u0131l Temizlenir (\u00d6rnek ile) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-11T01:22:18+00:00\",\"dateModified\":\"2023-07-11T01:22:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, VBA kullan\u0131larak bir \u00e7al\u0131\u015fma sayfas\u0131ndan filtrelerin nas\u0131l kald\u0131r\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba kullanarak excel&#39;de filtreler nas\u0131l temizlenir (\u00f6rnekle)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA Kullanarak Excel&#39;de Filtreler Nas\u0131l Temizlenir (\u00d6rnek ile) - Statorials","description":"Bu e\u011fitimde, VBA kullan\u0131larak bir \u00e7al\u0131\u015fma sayfas\u0131ndan filtrelerin nas\u0131l kald\u0131r\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA Kullanarak Excel&#39;de Filtreler Nas\u0131l Temizlenir (\u00d6rnek ile) - Statorials","og_description":"Bu e\u011fitimde, VBA kullan\u0131larak bir \u00e7al\u0131\u015fma sayfas\u0131ndan filtrelerin nas\u0131l kald\u0131r\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/","og_site_name":"Statorials","article_published_time":"2023-07-11T01:22:18+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cf1.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/","url":"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/","name":"VBA Kullanarak Excel&#39;de Filtreler Nas\u0131l Temizlenir (\u00d6rnek ile) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-11T01:22:18+00:00","dateModified":"2023-07-11T01:22:18+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, VBA kullan\u0131larak bir \u00e7al\u0131\u015fma sayfas\u0131ndan filtrelerin nas\u0131l kald\u0131r\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/vba-filtreyi-temizle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba kullanarak excel&#39;de filtreler nas\u0131l temizlenir (\u00f6rnekle)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4448"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4448\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}