{"id":1533,"date":"2023-11-17T15:38:17","date_gmt":"2023-11-17T15:38:17","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/dongu-icin\/"},"modified":"2023-12-10T06:05:34","modified_gmt":"2023-12-10T06:05:34","slug":"dongu-icin","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/dongu-icin\/","title":{"rendered":"Vba for loop (sonraki i\u0307\u00e7in, her biri i\u0307\u00e7in)"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3851007037\"><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 class=\"wp-block-heading\"><strong>Anahtar noktalar\u0131<\/strong><\/p><ul class=\"link\"><li> VBA For d\u00f6ng\u00fcleri sabit d\u00f6ng\u00fc t\u00fcrleridir.<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-kaydet\/\">Makro kaydederken<\/a> bu d\u00f6ng\u00fclerden birini kullanmak m\u00fcmk\u00fcn de\u011fildir.<\/li><\/ul><h2 class=\"wp-block-heading\"> Bir sonraki d\u00f6ng\u00fc i\u00e7in<\/h2><p> VBA FOR NEXT yinelemeleri y\u00fcr\u00fctmek i\u00e7in bir saya\u00e7 kullanan sabit bir d\u00f6ng\u00fcd\u00fcr. Basit bir ifadeyle, d\u00f6ng\u00fcy\u00fc ka\u00e7 kez \u00e7al\u0131\u015ft\u0131rmak istedi\u011finizi belirtmeniz gerekir ve bu d\u00f6ng\u00fc say\u0131s\u0131na ula\u015ft\u0131\u011f\u0131nda otomatik olarak duracakt\u0131r. Bu nedenle sabit bir d\u00f6ng\u00fcd\u00fcr ve VBA geli\u015ftiricileri aras\u0131nda en pop\u00fcler olan\u0131d\u0131r.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> \u0130\u015fte VBA For Next d\u00f6ng\u00fcs\u00fcn\u00fcn s\u00f6zdizimi: <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">For counter = Start To End [Step stepsize] [statements] Next [counter]<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51813\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-pour-le-compteur-du-debut-a-la-fin.png\" sizes=\"auto, \" srcset=\"\" alt=\"ba\u015ftan sona kar\u015f\u0131\" width=\"551\" height=\"192\"><\/figure><\/div><ol type=\"1\"><li> <strong>Saya\u00e7<\/strong> : Tekrar say\u0131s\u0131n\u0131 saklayan ve her tekrarda de\u011ferini art\u0131ran bir de\u011fi\u015fkendir. \u00d6rne\u011fin, d\u00f6ng\u00fc be\u015finci yinelemesindeyse saya\u00e7 de\u011feri be\u015f olur ve d\u00f6ng\u00fc be\u015finci yinelemenin talimat\u0131n\u0131 y\u00fcr\u00fctt\u00fc\u011f\u00fcnde saya\u00e7 de\u011feri alt\u0131ya de\u011fi\u015fir.<\/li><li> <strong>Start<\/strong> : Sayac\u0131n ba\u015flang\u0131\u00e7 de\u011ferini saklayan say\u0131sal bir de\u011fi\u015fkendir.<\/li><li> <strong>End<\/strong> : Sayac\u0131n son de\u011ferini saklayan say\u0131sal bir de\u011fi\u015fkendir.<\/li><li> <strong>Ad\u0131m boyutu<\/strong> : Bu de\u011fi\u015fken saya\u00e7 de\u011ferindeki b\u00fcy\u00fck art\u0131\u015f\u0131 veya azalmay\u0131 belirtir. Varsay\u0131lan olarak ad\u0131m boyutu birdir ancak herhangi bir pozitif veya negatif de\u011feri de kullanabilirsiniz.<\/li><li> <strong>A\u00e7\u0131klama<\/strong> : Bu, For Next d\u00f6ng\u00fcs\u00fcn\u00fcn her yinelemesinde \u00e7al\u0131\u015ft\u0131rmak istedi\u011finiz bir kod k\u00fcmesidir.<\/li><li> <strong>Sonraki<\/strong> : Bu, d\u00f6ng\u00fcn\u00fcn yinelenmesi i\u00e7in end ifadesidir ve VBA&#8217;ya d\u00f6ng\u00fcy\u00fc tekrarlamas\u0131n\u0131 s\u00f6ylemek i\u00e7in saya\u00e7 de\u011ferini kullan\u0131r ve saya\u00e7 biti\u015f de\u011ferine ula\u015ft\u0131\u011f\u0131nda d\u00f6ng\u00fcy\u00fc sonland\u0131r\u0131r.<\/li><\/ol><h3 class=\"wp-block-heading\"> Bir sonraki d\u00f6ng\u00fc i\u00e7in anla\u015f\u0131lmas\u0131 gereken \u00f6rnek<\/h3><p> Bir sonraki d\u00f6ng\u00fcde nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 anlamak i\u00e7in seri numaralar\u0131n\u0131 bir s\u00fctuna ekleyen basit bir kod yazal\u0131m.<\/p><p class=\"link\"> <strong>Biraz daha detayland\u0131ray\u0131m:<\/strong> A\u015fa\u011f\u0131daki anl\u0131k g\u00f6r\u00fcnt\u00fcde se\u00e7ilen h\u00fccreden sonraki 10 h\u00fccreye tek tek gidebilecek ve sadece seri numaralar\u0131n\u0131 ekleyebilecek bir kod yazmam\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51814\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-exemple-a-comprendre-pour-la-prochaine-boucle.png\" sizes=\"auto, \" srcset=\"\" alt=\"sonraki d\u00f6ng\u00fcn\u00fcn anla\u015f\u0131lmas\u0131 i\u00e7in \u00f6rnek\" width=\"231\" height=\"263\"><\/figure><\/div><p> <strong>For Next Loop&#8217;u kullanmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz:<\/strong><\/p><ol><li> \u00d6ncelikle saya\u00e7 de\u011ferini saklamak i\u00e7in kullanabilece\u011finiz bir de\u011fi\u015fken tan\u0131mlaman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-bir-de\u011fi\u015fken-bildirimi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-declarer-une-variable.png\" sizes=\"auto, \" srcset=\"\" alt=\"declare-a-variable\" width=\"352\" height=\"254\"><\/li><li> Daha sonra saya\u00e7 de\u011ferini de\u011fi\u015fkene atamam\u0131z gerekiyor. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-saya\u00e7 de\u011feri atama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-affecter-la-valeur-du-compteur.png\" sizes=\"auto, \" srcset=\"\" alt=\"assign-the-counter-value\" width=\"350\" height=\"264\"><\/li><li> \u015eimdi d\u00f6ng\u00fc i\u00e7in kod yazman\u0131n zaman\u0131 geldi, bu y\u00fczden ilk sat\u0131rda saya\u00e7 de\u011fi\u015fkenini kullanman\u0131z ve ba\u015flang\u0131\u00e7 ve biti\u015f de\u011ferlerini ayarlaman\u0131z gerekiyor. Bu kodda biti\u015f de\u011feri olarak &#8216;i&#8217; de\u011fi\u015fkenine sahipsiniz. <br><img loading=\"lazy\" decoding=\"async\" title=\"D\u00f6ng\u00fc i\u00e7in 5 kod yazma\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-ecrire-le-code-pour-la-boucle.png\" sizes=\"auto, \" srcset=\"\" alt=\"write-code-for-loop\" width=\"353\" height=\"284\"><\/li><li> Buradan seri numaralar\u0131n\u0131 aktif h\u00fccreye ekleyip bir sonraki h\u00fccreye ge\u00e7ebilecek kodu yazman\u0131z gerekiyor. Saya\u00e7 de\u011feri her yinelemede artt\u0131k\u00e7a, seri numaras\u0131n\u0131 aktif h\u00fccreye girmek i\u00e7in kullanabilirsiniz ve bundan sonra se\u00e7imi bir sonraki h\u00fccreye a\u015fa\u011f\u0131 ta\u015f\u0131mak i\u00e7in kayd\u0131rmay\u0131 kullanabilirsiniz. <br><img loading=\"lazy\" decoding=\"async\" title=\"Seri numaras\u0131 ekleyebilen 6 kod\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-code-qui-peut-ajouter-le-numero-de-serie.png\" sizes=\"auto, \" srcset=\"\" alt=\"code-that-can-add-serial-number\" width=\"404\" height=\"288\"><\/li><li> Sonunda d\u00f6ng\u00fc kodunu tamamlamak i\u00e7in next anahtar s\u00f6zc\u00fc\u011f\u00fcn\u00fc ve saya\u00e7 de\u011fi\u015fkenini kullan\u0131n.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub AddSerialNumbers() Dim i As Integer i = 10 For i = 1 To i ActiveCell.Value = i ActiveCell.Offset(1, 0).Activate Next i End Sub<\/code><\/pre><p> A\u015fa\u011f\u0131daki anl\u0131k g\u00f6r\u00fcnt\u00fcde g\u00f6rebilece\u011finiz gibi, bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131mda seri numaras\u0131 girilerek se\u00e7ilen h\u00fccreden ba\u015fl\u0131yor ve her yinelemede bir sonraki h\u00fccreye ge\u00e7iyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51851\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/vba-pour-lexemple-de-boucle-suivante-1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"vba-sonraki d\u00f6ng\u00fc \u00f6rne\u011fi-1 i\u00e7in\" width=\"568\" height=\"390\"><\/figure><\/div><p> Bildi\u011finiz gibi For Next sabit bir d\u00f6ng\u00fcd\u00fcr ve bu kodda say\u0131sal bir de\u011fer atad\u0131\u011f\u0131n\u0131zda VBA&#8217;ya d\u00f6ng\u00fcy\u00fc o say\u0131da \u00e7al\u0131\u015ft\u0131rmas\u0131n\u0131 s\u00f6yler.<\/p><p> A\u015fa\u011f\u0131da d\u00f6ng\u00fcn\u00fcn ikinci yinelemesinde \u00e7ekti\u011fim, saya\u00e7 de\u011fi\u015fkeni \u201ci\u201dnin de\u011ferinin iki oldu\u011fu anl\u0131k g\u00f6r\u00fcnt\u00fcy\u00fc g\u00f6rebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51819\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-attribuer-une-valeur-numerique.png\" sizes=\"auto, \" srcset=\"\" alt=\"say\u0131sal bir de\u011fer atay\u0131n\" width=\"461\" height=\"334\"><\/figure><\/div><p> Vurgulamaya \u00e7al\u0131\u015ft\u0131\u011f\u0131m nokta, say\u0131m de\u011fi\u015fkeninin her yinelemede de\u011ferini de\u011fi\u015ftirmesi ve bu de\u011feri aktif h\u00fccreye girmesi, ard\u0131ndan kayd\u0131rman\u0131n bir sonraki h\u00fccreyi etkinle\u015ftirerek yinelemeyi tamamlamas\u0131d\u0131r.<\/p><p> Sonunda, d\u00f6ng\u00fcn\u00fcn ilk sat\u0131r\u0131na d\u00f6nmek ve onu tekrarlamak i\u00e7in \u201cSonraki\u201d anahtar s\u00f6zc\u00fc\u011f\u00fc VBA&#8217;d\u0131r. For Next s\u00f6zdiziminde g\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi, sayac\u0131 buna g\u00f6re \u00e7al\u0131\u015ft\u0131rmak i\u00e7in d\u00f6ng\u00fcdeki bir ad\u0131m de\u011ferini de kullanabilirsiniz.<\/p><p> Yani ad\u0131m de\u011feri olarak ikiyi kullan\u0131rsan\u0131z kod a\u015fa\u011f\u0131daki gibi g\u00f6r\u00fcnecektir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub AddSerialNumbers() Dim i As Integer i = 10 For i = 1 To i Step 2 ActiveCell.Value = i ActiveCell.Offset(1, 0).Activate Next i End Sub<\/code><\/pre><p> Ve bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, aktivitede a\u015fa\u011f\u0131daki anl\u0131k g\u00f6r\u00fcnt\u00fcye benzer bir \u015fey olacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51820\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-lorsque-vous-executez-un-instantane-de-code.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir kodun anl\u0131k g\u00f6r\u00fcnt\u00fcs\u00fcn\u00fc \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda\" width=\"552\" height=\"426\"><\/figure><\/div><p> Bir ad\u0131m de\u011feri kulland\u0131\u011f\u0131n\u0131zda (yukar\u0131daki kodda kulland\u0131\u011f\u0131n\u0131z ad\u0131m 2 gibi), VBA d\u00f6ng\u00fcdeki her 2. yinelemeyi yok sayar ve g\u00f6rebilece\u011finiz gibi, her say\u0131da bir farkla be\u015f say\u0131n\u0131z olur.<\/p><p class=\"qt-tip\"> <strong>Not<\/strong> : Yukar\u0131daki \u00f6rnekte saya\u00e7 <a href=\"https:\/\/exceladvisor.org\/tr\/degiskenler\/\">de\u011fi\u015fkeni<\/a> olarak &#8216;i&#8217;yi kulland\u0131n\u0131z, ancak size kolayl\u0131k olmas\u0131 a\u00e7\u0131s\u0131ndan farkl\u0131 bir ad da kullanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Sonraki her d\u00f6ng\u00fc i\u00e7in<\/h2><p> VBA FOR ECH NEXT, bir koleksiyondaki t\u00fcm nesneler aras\u0131nda d\u00f6ng\u00fc yapabilen sabit bir d\u00f6ng\u00fcd\u00fcr. Her Sonraki \u0130\u00e7in&#8217;de yineleme say\u0131s\u0131n\u0131 belirtmenize gerek yoktur. Bunun yerine, bir nesne koleksiyonu belirtebilirsiniz ve bu, t\u00fcm bu nesneler aras\u0131nda tek tek yineleme yapabilecektir.<\/p><p class=\"link\"> <strong>\u00d6rne\u011fin<\/strong> : Bir aral\u0131ktaki t\u00fcm h\u00fccrelere g\u00f6z atmak istiyorsan\u0131z. Bu durumda <a href=\"https:\/\/exceladvisor.org\/tr\/aralik-1\/\">aral\u0131k<\/a> koleksiyondur ve h\u00fccreler sahip oldu\u011funuz nesnelerdir.<\/p><h3 class=\"wp-block-heading\"> S\u00f6zdizimi<\/h3><p> Sonraki her d\u00f6ng\u00fc i\u00e7in VBA s\u00f6zdizimi a\u015fa\u011f\u0131da verilmi\u015ftir: <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">For Each Object In Collection [statements] Next [object]<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51821\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-syntaxe-pour-le-vba-pour-chaque-boucle-suivante.png\" sizes=\"auto, \" srcset=\"\" alt=\"her-sonraki-d\u00f6ng\u00fc i\u00e7in-vba-i\u00e7in-s\u00f6zdizimi\" width=\"604\" height=\"199\"><\/figure><\/div><ol type=\"1\"><li> <strong>Object<\/strong> : Nesne koleksiyonunda d\u00f6ng\u00fc yapt\u0131\u011f\u0131n\u0131z tek nesneyi temsil eder. Her yinelemede bir nesneden di\u011ferine gider.<\/li><li> <strong>Koleksiyon<\/strong> : Bu, d\u00f6ng\u00fc yapmak istedi\u011finiz nesnelerin bir koleksiyonudur.<\/li><li> <strong>A\u00e7\u0131klama<\/strong> : Koleksiyondaki t\u00fcm nesneler boyunca her d\u00f6ng\u00fcde \u00e7al\u0131\u015ft\u0131rmak istedi\u011finiz kod sat\u0131rlar\u0131.<\/li><li> <strong>Next<\/strong> : Bu, d\u00f6ng\u00fc yinelemesinin end ifadesidir ve VBA&#8217;ya koleksiyondaki bir sonraki nesneye ge\u00e7mesini s\u00f6yler.<\/li><\/ol><h3 class=\"wp-block-heading\"> Her Sonraki D\u00f6ng\u00fcy\u00fc Anlamak \u0130\u00e7in \u00d6rnek<\/h3><p> For Every Next d\u00f6ng\u00fcs\u00fcn\u00fc anlamak i\u00e7in aktif \u00e7al\u0131\u015fma sayfas\u0131 d\u0131\u015f\u0131ndaki t\u00fcm sayfalar\u0131 gizleyecek kod yazal\u0131m. Bu kod, her \u00e7al\u0131\u015fma sayfas\u0131n\u0131n ad\u0131n\u0131 kontrol edecek ve onu etkin \u00e7al\u0131\u015fma sayfas\u0131n\u0131n ad\u0131yla e\u015fle\u015ftirecek ve e\u015fle\u015fmezse gizleyecektir.<\/p><p> Her Sonraki \u0130\u00e7in d\u00f6ng\u00fcs\u00fcn\u00fc kullanmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz:<\/p><ol><li> \u00d6ncelikle \u00e7al\u0131\u015fma sayfas\u0131 olarak kullan\u0131lacak bir de\u011fi\u015fken bildirmeniz gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"T\u00fcm sayfalar\u0131 gizlemek i\u00e7in 10 kod\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-code-pour-cacher-toutes-les-feuilles.png\" sizes=\"auto, \" srcset=\"\" alt=\"code-to-hide-the-all-sheets\" width=\"373\" height=\"215\"><\/li><li> Bundan sonra, &#8220;Her Biri \u0130\u00e7in&#8221; anahtar kelimesini, ard\u0131ndan sayfa i\u00e7in &#8220;mySheet&#8221; de\u011fi\u015fkenini kullan\u0131n ve etkin \u00e7al\u0131\u015fma kitab\u0131n\u0131n \u00e7al\u0131\u015fma sayfas\u0131 koleksiyonu i\u00e7in &#8220;ActiveWorkbook.Worksheets&#8221;i kullan\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"11-her-sayfam-etkin-\u00e7al\u0131\u015fma-kitap-\u00e7al\u0131\u015fma sayfas\u0131 i\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-pour-chaque-feuille-de-travail-de-classeur-actif-mysheet.png\" sizes=\"auto, \" srcset=\"\" alt=\"for-each-mysheet-active-workbook-worsheets\" width=\"440\" height=\"209\"><\/li><li> Daha sonra, \u015fu anda bu d\u00f6ng\u00fc yinelemesinde bulunan sayfan\u0131n ad\u0131n\u0131n etkin \u00e7al\u0131\u015fma sayfas\u0131na E\u015e\u0130T OLMADI\u011eINI test etmek i\u00e7in VBA IF ifadesini kullanman\u0131z gerekir ve bu ko\u015ful do\u011fruysa, \u015fu anda d\u00f6ng\u00fcde olan sayfay\u0131 gizleyin yineleme. <br><img loading=\"lazy\" decoding=\"async\" title=\"12-vba-if-test edilecek-ifadesi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-vba-si-instruction-a-tester.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-if-statement-to-test\" width=\"432\" height=\"331\"><\/li><li> Sonunda, d\u00f6ng\u00fc kodunu tamamlamak i\u00e7in NEXT anahtar s\u00f6zc\u00fc\u011f\u00fcne ve &#8220;mySheet&#8221; de\u011fi\u015fkenine sahipsiniz. <br><img loading=\"lazy\" decoding=\"async\" title=\"13-sonraki-anahtar kelime-ve-mafeuille\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-mot-cle-suivant-et-ma-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"next-keyword-and-mysheet\" width=\"435\" height=\"325\"><\/li><\/ol><p> <strong>Son kod:<\/strong><\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub Hide_Other_Sheets() Dim mySheet As Worksheet For Each mySheet In ActiveWorkbook.Worksheets If mySheet.Name &lt;&gt; ActiveSheet.Name Then mySheet.Visible = False End If Next mySheet End Sub<\/code><\/pre><p class=\"link\"> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">Bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda<\/a> , etkin \u00e7al\u0131\u015fma kitab\u0131ndaki her \u00e7al\u0131\u015fma sayfas\u0131n\u0131n \u00fczerinden ge\u00e7erek kendi ad\u0131n\u0131 etkin \u00e7al\u0131\u015fma sayfas\u0131yla e\u015fle\u015ftirir ve \u00e7al\u0131\u015fma sayfas\u0131n\u0131n ad\u0131, etkin \u00e7al\u0131\u015fma sayfas\u0131n\u0131n ad\u0131yla e\u015fle\u015fmiyorsa bunu yapar. maske.<\/p><p> Bu \u015fekilde t\u00fcm \u00e7al\u0131\u015fma sayfalar\u0131 gizlenecektir.<\/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\/donguler\/\">VBA D\u00f6ng\u00fcleri (Ba\u015flang\u0131\u00e7tan \u0130leri Seviyeye)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/davayi-sec\/\">VBA Se\u00e7me Vakas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bu-arada-yapmak\/\">Excel VBA Do While D\u00f6ng\u00fcs\u00fc ve (Do Loop While) \u2013 Bir K\u0131lavuz<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-yapraklari\/\">Excel&#8217;de VBA&#8217;y\u0131 kullanarak t\u00fcm sayfalar aras\u0131nda ge\u00e7i\u015f yap\u0131n<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aralik-boyunca-dongu\/\">VBA (S\u00fctunlar, Sat\u0131r ve Kullan\u0131lm\u0131\u015fRange) kullanarak bir aral\u0131kta d\u00f6ng\u00fc yap\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/1e-git\/\">GoTo VBA bildirimi<\/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-1533","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>VBA FOR LOOP (Sonraki \u0130\u00e7in, Her Biri \u0130\u00e7in) = K\u0131lavuz + \u00d6rnekler 2023<\/title>\n<meta name=\"description\" content=\"VBA FOR NEXT yinelemeleri y\u00fcr\u00fctmek i\u00e7in bir saya\u00e7 kullanan sabit bir d\u00f6ng\u00fcd\u00fcr. Basit bir ifadeyle, numaray\u0131 belirtmeniz gerekir\" \/>\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\/dongu-icin\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA FOR LOOP (Sonraki \u0130\u00e7in, Her Biri \u0130\u00e7in) = K\u0131lavuz + \u00d6rnekler 2023\" \/>\n<meta property=\"og:description\" content=\"VBA FOR NEXT yinelemeleri y\u00fcr\u00fctmek i\u00e7in bir saya\u00e7 kullanan sabit bir d\u00f6ng\u00fcd\u00fcr. Basit bir ifadeyle, numaray\u0131 belirtmeniz gerekir\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:05:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-pour-le-compteur-du-debut-a-la-fin.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=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\",\"name\":\"VBA FOR LOOP (Sonraki \u0130\u00e7in, Her Biri \u0130\u00e7in) = K\u0131lavuz + \u00d6rnekler 2023\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-pour-le-compteur-du-debut-a-la-fin.png\",\"datePublished\":\"2023-11-17T15:38:17+00:00\",\"dateModified\":\"2023-12-10T06:05:34+00:00\",\"description\":\"VBA FOR NEXT yinelemeleri y\u00fcr\u00fctmek i\u00e7in bir saya\u00e7 kullanan sabit bir d\u00f6ng\u00fcd\u00fcr. Basit bir ifadeyle, numaray\u0131 belirtmeniz gerekir\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-pour-le-compteur-du-debut-a-la-fin.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-pour-le-compteur-du-debut-a-la-fin.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba for loop (sonraki i\u0307\u00e7in, her biri i\u0307\u00e7in)\"}]},{\"@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":"VBA FOR LOOP (Sonraki \u0130\u00e7in, Her Biri \u0130\u00e7in) = K\u0131lavuz + \u00d6rnekler 2023","description":"VBA FOR NEXT yinelemeleri y\u00fcr\u00fctmek i\u00e7in bir saya\u00e7 kullanan sabit bir d\u00f6ng\u00fcd\u00fcr. Basit bir ifadeyle, numaray\u0131 belirtmeniz gerekir","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\/dongu-icin\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA FOR LOOP (Sonraki \u0130\u00e7in, Her Biri \u0130\u00e7in) = K\u0131lavuz + \u00d6rnekler 2023","og_description":"VBA FOR NEXT yinelemeleri y\u00fcr\u00fctmek i\u00e7in bir saya\u00e7 kullanan sabit bir d\u00f6ng\u00fcd\u00fcr. Basit bir ifadeyle, numaray\u0131 belirtmeniz gerekir","og_url":"https:\/\/exceladvisor.org\/tr\/dongu-icin\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:05:34+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-pour-le-compteur-du-debut-a-la-fin.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/dongu-icin\/","url":"https:\/\/exceladvisor.org\/tr\/dongu-icin\/","name":"VBA FOR LOOP (Sonraki \u0130\u00e7in, Her Biri \u0130\u00e7in) = K\u0131lavuz + \u00d6rnekler 2023","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/dongu-icin\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/dongu-icin\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-pour-le-compteur-du-debut-a-la-fin.png","datePublished":"2023-11-17T15:38:17+00:00","dateModified":"2023-12-10T06:05:34+00:00","description":"VBA FOR NEXT yinelemeleri y\u00fcr\u00fctmek i\u00e7in bir saya\u00e7 kullanan sabit bir d\u00f6ng\u00fcd\u00fcr. Basit bir ifadeyle, numaray\u0131 belirtmeniz gerekir","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/dongu-icin\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/dongu-icin\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/dongu-icin\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-pour-le-compteur-du-debut-a-la-fin.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-pour-le-compteur-du-debut-a-la-fin.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/dongu-icin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba for loop (sonraki i\u0307\u00e7in, her biri i\u0307\u00e7in)"}]},{"@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\/1533","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=1533"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1533\/revisions"}],"predecessor-version":[{"id":2819,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1533\/revisions\/2819"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}