{"id":2051,"date":"2023-10-22T17:02:51","date_gmt":"2023-10-22T17:02:51","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/aralik-1\/"},"modified":"2023-12-10T06:07:27","modified_gmt":"2023-12-10T06:07:27","slug":"aralik-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/aralik-1\/","title":{"rendered":"Vba&#39;da aral\u0131k ve h\u00fccreler nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2523661552\"><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> <h2 class=\"wp-block-heading\">VBA&#8217;da Aral\u0131k ve H\u00fccrelere Giri\u015f<\/h2><p> Bir Excel \u00e7al\u0131\u015fma kitab\u0131na bakt\u0131\u011f\u0131n\u0131zda h\u00fccrelerin etraf\u0131nda her \u015feyin \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 g\u00f6receksiniz. Bir h\u00fccre ve h\u00fccre aral\u0131\u011f\u0131, verilerinizi depolad\u0131\u011f\u0131n\u0131z yerdir ve sonra her \u015fey ba\u015flar.<\/p><p> VBA&#8217;dan en iyi \u015fekilde yararlanmak i\u00e7in kodlar\u0131n\u0131zdaki h\u00fccreleri ve aral\u0131klar\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenmeniz gerekir. Bunun i\u00e7in Range nesneleri hakk\u0131nda sa\u011flam bir anlay\u0131\u015fa sahip olman\u0131z gerekir. Bunu kullanarak kodlar\u0131n\u0131zdaki h\u00fccrelere a\u015fa\u011f\u0131daki \u015fekilde ba\u015fvurabilirsiniz:<\/p><ul><li> Tek bir h\u00fccre.<\/li><li> Bir dizi h\u00fccre<\/li><li> Bir sat\u0131r veya s\u00fctun<\/li><li> \u00dc\u00e7 boyutlu bir aral\u0131k<\/li><\/ul><p> ARALIK NESNE, Excel&#8217;in nesne hiyerar\u015fisinin bir par\u00e7as\u0131d\u0131r: <strong>Uygulama \u279c \u00c7al\u0131\u015fma Kitaplar\u0131 \u279c \u00c7al\u0131\u015fma Sayfalar\u0131 \u279c Aral\u0131k<\/strong> ve \u00e7al\u0131\u015fma sayfas\u0131n\u0131n i\u00e7indeki ba\u015fka yerler. Dolay\u0131s\u0131yla, RANGE nesnesine at\u0131fta bulunmak i\u00e7in kod yazarsan\u0131z, \u015f\u00f6yle olur:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Application.Workbook(\u201cWorkbook-Name\u201d).Worksheets(\u201cSheet-Name\u201d).Range<\/code><\/pre><p> Bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na ba\u015fvurarak a\u015fa\u011f\u0131dakileri yapabilirsiniz:<\/p><ul><li> De\u011feri okuyabilirsiniz.<\/li><li> Oraya bir de\u011fer girebilirsiniz.<\/li><li> Ve formatta de\u011fi\u015fiklik yapabilirsiniz.<\/li><\/ul><p> T\u00fcm bunlar\u0131 yapmak i\u00e7in bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na nas\u0131l ba\u015fvuruda bulunaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenmeniz gerekir ve bu e\u011fitimin bir sonraki b\u00f6l\u00fcm\u00fcnde bir h\u00fccreye farkl\u0131 \u015fekillerde nas\u0131l ba\u015fvuruda bulunaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz. Bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na ba\u015fvurmak i\u00e7in \u00fc\u00e7 farkl\u0131 y\u00f6ntem kullanabilirsiniz.<\/p><ul><li> Plaj m\u00fclk\u00fc<\/li><li> H\u00fccre \u00f6zelli\u011fi<\/li><li> Ofset \u00d6zelli\u011fi<\/li><\/ul><p> Peki, bunlardan hangisinin en iyisi ihtiya\u00e7lar\u0131n\u0131za ba\u011fl\u0131d\u0131r, ancak size en uygun olan\u0131 se\u00e7ebilmeniz i\u00e7in \u00fc\u00e7\u00fcn\u00fc de \u00f6\u011frenmeye de\u011fer.<\/p><p> \u00d6yleyse ba\u015flayal\u0131m.<\/p><h2 class=\"wp-block-heading\"> Plaj m\u00fclk\u00fc<\/h2><p> Range \u00f6zelli\u011fi, VBA kodlar\u0131n\u0131zdaki bir aral\u0131\u011fa ba\u015fvurman\u0131n en yayg\u0131n ve pop\u00fcler yoludur. Range \u00f6zelli\u011fi ile h\u00fccre adresine ba\u015fvurman\u0131z yeterlidir. Size s\u00f6zdizimini anlatay\u0131m.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">expression.range(address)<\/code><\/pre><p> Burada ifade, bir VBA nesnesini temsil eden bir de\u011fi\u015fkendir. Yani A1 h\u00fccresine ba\u015fvurman\u0131z gerekiyorsa yazman\u0131z gereken kod sat\u0131r\u0131 \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Application.Workbook(\u201cBook1\u201d).Worksheets(\u201cSheet1\u201d).Range(\u201cA1\u201d)<\/code><\/pre><p> Yukar\u0131daki kod, VBA&#8217;ya &#8220;Sayfa1&#8221; \u00e7al\u0131\u015fma sayfas\u0131nda ve &#8220;Kitap1&#8221; \u00e7al\u0131\u015fma kitab\u0131nda bulunan A1 h\u00fccresine ba\u015fvurdu\u011funuzu bildirir.<\/p><p class=\"qt-tip\"> <strong>Not:<\/strong> Aral\u0131k nesnesine bir h\u00fccre adresi girdi\u011finizde, onu \u00e7ift t\u0131rnak i\u00e7ine ald\u0131\u011f\u0131n\u0131zdan emin olun. <strong>Ama burada anla\u015f\u0131lmas\u0131 gereken bir \u015fey var.<\/strong> Excel&#8217;de VBA kulland\u0131\u011f\u0131n\u0131z i\u00e7in &#8220;Uygulama&#8221; kelimesini kullanman\u0131za gerek yoktur. Yani kod \u015f\u00f6yle olurdu:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbook(\u201cBook1\u201d).Worksheets(\u201cSheet1\u201d).Range(\u201cA1\u201d)<\/code><\/pre><p> Ve e\u011fer Kitap1&#8217;deyseniz kodunuzu daha da azaltabilirsiniz:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\u201cSheet1\u201d).Range(\u201cA1\u201d)<\/code><\/pre><p> Ancak zaten &#8220;Sayfa1&#8221; \u00e7al\u0131\u015fma sayfas\u0131ndaysan\u0131z kodunuzu daha da azaltabilirsiniz ve yaln\u0131zca \u015funlar\u0131 kullanabilirsiniz:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\u201cA1\u201d)<\/code><\/pre><p> \u015eimdi, t\u00fcm h\u00fccre aral\u0131\u011f\u0131na (yani birden fazla h\u00fccreye) ba\u015fvurmak istedi\u011finizi varsayal\u0131m, kodu \u015fu \u015fekilde yazman\u0131z gerekir:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A5\")<\/code><\/pre><p> Yukar\u0131daki kodda be\u015f h\u00fccreden olu\u015fan A1 ila A5 aral\u0131\u011f\u0131n\u0131 ifade ettiniz. Range nesnesini kullanarak adland\u0131r\u0131lm\u0131\u015f bir aral\u0131\u011fa da ba\u015fvurabilirsiniz. Diyelim ki &#8220;Sat\u0131\u015f \u0130ndirimi&#8221; ad\u0131nda bir adland\u0131r\u0131lm\u0131\u015f aral\u0131\u011f\u0131n\u0131z var, \u015f\u00f6yle bir kod yazabilirsiniz:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"Sales Discount\")<\/code><\/pre><p> S\u00fcrekli olmayan bir aral\u0131\u011fa at\u0131fta bulunmak istiyorsan\u0131z \u015funun gibi bir \u015fey yapman\u0131z gerekir:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:B5,D5:G10\")<\/code><\/pre><p> Ve e\u011fer bir sat\u0131r\u0131n veya s\u00fctunun tamam\u0131na at\u0131fta bulunmak istiyorsan\u0131z a\u015fa\u011f\u0131dakine benzer bir kod girmeniz gerekir:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"1:1\") Range(\"A:A\")<\/code><\/pre><p> Bu noktada bir h\u00fccreye ve h\u00fccre aral\u0131\u011f\u0131na nas\u0131l at\u0131fta bulunaca\u011f\u0131n\u0131z\u0131 a\u00e7\u0131k\u00e7a anl\u0131yorsunuz. Ancak bu konuda en iyi olmak i\u00e7in, onu ba\u015fka \u015feyler yapmak i\u00e7in nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011frenmeniz gerekir. <\/p><div id=\"ub-content-toggle-1d6c723f-ee3b-427f-b540-54681fa18f05\" class=\"wp-block-ub-content-toggle\" data-mobilecollapse=\"false\" data-desktopcollapse=\"true\"><div class=\"wp-block-ub-content-toggle-accordion\"><div class=\"wp-block-ub-content-toggle-accordion-title-wrap\" tabindex=\"0\" aria-expanded=\"false\" aria-controls=\"ub-content-toggle-panel-0-1d6c723f-ee3b-427f-b540-54681fa18f05\"><p class=\"wp-block-ub-content-toggle-accordion-title ub-content-toggle-title-1d6c723f-ee3b-427f-b540-54681fa18f05\"> Burada, VBA&#8217;da aral\u0131klar ve h\u00fccrelerle nas\u0131l \u00e7al\u0131\u015f\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenmek i\u00e7in kullanabilece\u011finiz kapsaml\u0131 bir \u00f6\u011fretici listemiz var. <\/p><\/div><div id=\"ub-content-toggle-panel-0-1d6c723f-ee3b-427f-b540-54681fa18f05\" class=\"wp-block-ub-content-toggle-accordion-content-wrap ub-hide\" role=\"region\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satir-sayisi\/\">Excel&#8217;de VBA kullanarak sat\u0131rlar\u0131 sayma<\/a><\/li><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\/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><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bir-satir-ekle-1\/\">Excel&#8217;de VBA kullanarak sat\u0131r ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/\">VBA kodunu kullanarak Excel&#8217;deki h\u00fccreleri birle\u015ftirme<\/a><\/li><li> Excel&#8217;de VBA&#8217;y\u0131 kullanarak bir aral\u0131k\/h\u00fccre se\u00e7in<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hepsini-sec\/\">VBA kodunu kullanarak \u00e7al\u0131\u015fma sayfas\u0131ndaki T\u00dcM h\u00fccreleri SE\u00c7\u0130N<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/aktif-hucre-1\/\">Excel&#8217;de VBA&#8217;da ActiveCell<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ozel-hucreler\/\">Excel&#8217;de VBA&#8217;da \u00d6zel H\u00fccreler Y\u00f6ntemi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/\">Excel&#8217;de VBA&#8217;da Kullan\u0131lanRange \u00f6zelli\u011fi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/otomatik-ayarlama-1\/\">VBA otomatik s\u0131\u011fd\u0131rma (sat\u0131rlar, s\u00fctunlar veya \u00e7al\u0131\u015fma sayfas\u0131n\u0131n tamam\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/icerigi-temizle-1\/\">VBA ClearContents (bir h\u00fccreden, aral\u0131ktan veya \u00e7al\u0131\u015fma sayfas\u0131n\u0131n tamam\u0131ndan)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucreyi-yeni-calisma-sayfasina-kopyala\/\">VBA aral\u0131\u011f\u0131n\u0131 ba\u015fka bir sayfaya + \u00e7al\u0131\u015fma kitab\u0131na kopyala<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/hucre-degeri\/\">VBA H\u00fccreye bir de\u011fer girin (Ayarla, Al ve De\u011fi\u015ftir)<\/a><\/li><li> VBA Ekleme S\u00fctunu (Tekli ve \u00c7oklu)<\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/isimli-plaj\/\">Aral\u0131k adl\u0131 VBA | (Statik + Se\u00e7im + Dinamik)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/menzil-kaymasi\/\">VBA Aral\u0131\u011f\u0131 Uzakl\u0131\u011f\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/araligi-sirala\/\">VBA s\u0131ralama aral\u0131\u011f\u0131 | (Azalan, birden \u00e7ok s\u00fctun, s\u0131ralama y\u00f6n\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/metni-kaydir-1\/\">VBA Sarma Metni (h\u00fccre, aral\u0131k ve \u00e7al\u0131\u015fma sayfas\u0131n\u0131n tamam\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/bos-hucreyi-kontrol-et\/\">VBA Bir h\u00fccrenin bo\u015f + birden fazla h\u00fccre olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/a><\/li><\/ul><\/div><\/div><\/div><h3 class=\"wp-block-heading\"> 1. Bir h\u00fccreyi se\u00e7in ve etkinle\u015ftirin<\/h3><p> Bir h\u00fccreyi se\u00e7mek istiyorsan\u0131z aral\u0131\u011f\u0131 kullanabilirsiniz. Y\u00f6ntemi se\u00e7in. Diyelim ki A5 h\u00fccresini se\u00e7mek istiyorsan\u0131z aral\u0131\u011f\u0131 belirtmeniz ve ard\u0131ndan &#8220;.Select&#8221; eklemeniz yeterli.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\u201cA1\u201d).Select<\/code><\/pre><p> Bu kod, VBA&#8217;ya A5 h\u00fccresini se\u00e7mesini s\u00f6yler ve e\u011fer bir h\u00fccre aral\u0131\u011f\u0131 se\u00e7mek istiyorsan\u0131z o aral\u0131\u011fa bak\u0131n ve ard\u0131ndan &#8220;.Select&#8221; ifadesini ekleyin.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\u201cA1:A5\u201d).Select<\/code><\/pre><p> Bir h\u00fccreyi aktive etmek i\u00e7in kullanabilece\u011finiz ba\u015fka bir y\u00f6ntem de vard\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\u201cA1\u201d).Activate<\/code><\/pre><p> Burada ayn\u0131 anda yaln\u0131zca bir h\u00fccreyi aktive edebilece\u011finizi unutmaman\u0131z gerekiyor. \u201c.Activate <strong>\u201d<\/strong> metodu ile bir aral\u0131k belirtseniz bile o aral\u0131\u011f\u0131 se\u00e7ecektir ancak aktif olan h\u00fccre aral\u0131ktaki ilk h\u00fccre olacakt\u0131r.<\/p><h3 class=\"wp-block-heading\"> 2. H\u00fccreye bir de\u011fer girin<\/h3><p> Range \u00f6zelli\u011fini kullanarak bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na de\u011fer girebilirsiniz. Basit bir \u00f6rnek kullanarak nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlayal\u0131m:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Value = \"Exceladvisor\"<\/code><\/pre><p> Yukar\u0131daki \u00f6rnekte aral\u0131k olarak A1&#8217;i belirttiniz ve ard\u0131ndan VBA&#8217;ya h\u00fccrenin value \u00f6zelli\u011fine eri\u015fmesini s\u00f6yleyen &#8221; <strong>.Value<\/strong> &#8221; eklediniz.<\/p><p> Bir sonraki ad\u0131m e\u015fittir i\u015fareti ve ard\u0131ndan girmek istedi\u011finiz de\u011ferdir (bir metin de\u011feri girerseniz \u00e7ift t\u0131rnak kullanman\u0131z gerekir). Bir say\u0131 i\u00e7in kod \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Value = 9988<\/code><\/pre><p> Ve e\u011fer bir h\u00fccre aral\u0131\u011f\u0131na, yani birden fazla h\u00fccreye bir de\u011fer girmek istiyorsan\u0131z, o zaman tek yapman\u0131z gereken o aral\u0131\u011f\u0131 belirtmektir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A5\").Value = \"Exceladvisor\"<\/code><\/pre><p> Ve e\u011fer s\u00fcrekli olmayan aral\u0131\u011fa at\u0131fta bulunuyorsan\u0131z kod buradad\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A5 , E2:E3\").Value = \"Exceladvisor\"<\/code><\/pre><h3 class=\"wp-block-heading\"> 3. Bir h\u00fccreyi\/aral\u0131\u011f\u0131 kopyalay\u0131p yap\u0131\u015ft\u0131r\u0131n<\/h3><p> Range \u00f6zelli\u011fiyle, bir h\u00fccreyi kopyalay\u0131p hedef h\u00fccreye yap\u0131\u015ft\u0131rmak i\u00e7in &#8220;.Copy&#8221; y\u00f6ntemini kullanabilirsiniz. Diyelim ki A5 h\u00fccresini kopyalaman\u0131z gerekiyor, kar\u015f\u0131l\u0131k gelen kod \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A5\").Copy<\/code><\/pre><p> Bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda yaln\u0131zca A5 h\u00fccresi kopyalan\u0131r, ancak sonraki ad\u0131m bu kopyalanan h\u00fccreyi hedef h\u00fccreye yap\u0131\u015ft\u0131rmakt\u0131r. Bunu yapmak i\u00e7in, hedef anahtar kelimeyi ve ard\u0131ndan onu yap\u0131\u015ft\u0131rmak istedi\u011finiz h\u00fccreyi eklemelisiniz. Yani A1 h\u00fccresini kopyalay\u0131p E5 h\u00fccresine yap\u0131\u015ft\u0131rmak istiyorsan\u0131z kod \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Copy Destination:=Range(\"E5\")<\/code><\/pre><p> Benzer \u015fekilde, birden fazla h\u00fccreden olu\u015fan bir aral\u0131kla \u00e7al\u0131\u015f\u0131yorsan\u0131z kod \u015f\u00f6yle g\u00f6r\u00fcnecektir:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A5\").Copy Destination:=Range(\"E5:E9\")<\/code><\/pre><p> Bir h\u00fccre aral\u0131\u011f\u0131n\u0131 kopyalad\u0131ysan\u0131z ve ard\u0131ndan hedef aral\u0131k olarak bir h\u00fccreden bahsettiyseniz, VBA kopyalanan aral\u0131\u011f\u0131n tamam\u0131n\u0131 hedef olarak belirtti\u011finiz h\u00fccreden kopyalayacakt\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A5\").Copy Destination:=Range(\"B1\")<\/code><\/pre><p> Yukar\u0131daki kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, hedef aral\u0131k olarak yaln\u0131zca B1&#8217;den bahsetmi\u015f olsan\u0131z bile VBA, A1:A5 aral\u0131\u011f\u0131n\u0131 kopyalar ve B1:B5&#8217;e yap\u0131\u015ft\u0131r\u0131r.<\/p><p class=\"qt-tip\"> <strong>\u0130pucu:<\/strong> T\u0131pk\u0131 \u201c.Copy\u201d y\u00f6nteminde oldu\u011fu gibi, bir h\u00fccreyi kesmek i\u00e7in \u201c.Cut\u201d y\u00f6ntemini kullanabilir, ard\u0131ndan onu yap\u0131\u015ft\u0131rmak i\u00e7in bir hedef kullanabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 4. Font \u00f6zelli\u011fini Range \u00f6zelli\u011fiyle birlikte kullan\u0131n<\/h3><p> Range \u00f6zelli\u011fiyle, bir h\u00fccrenin t\u00fcm yaz\u0131 tipi ayarlar\u0131n\u0131 de\u011fi\u015ftirmenize yard\u0131mc\u0131 olan yaz\u0131 tipi \u00f6zelli\u011fine eri\u015febilirsiniz. Yaz\u0131 tipinin eri\u015febilece\u011finiz toplam 18 farkl\u0131 \u00f6zelli\u011fi vard\u0131r. Diyelim ki A1 h\u00fccresindeki metni kal\u0131n yapmak istiyorsunuz, kod \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Font.Bold = True<\/code><\/pre><p> Bu kod, VBA&#8217;ya A1 aral\u0131\u011f\u0131ndaki yaz\u0131 tipinin BOLD \u00f6zelli\u011fine eri\u015fmesini s\u00f6yler ve siz bu \u00f6zelli\u011fi TRUE olarak ayarlad\u0131n\u0131z. \u015eimdi A1 h\u00fccresine <a href=\"https:\/\/exceladvisor.org\/tr\/kamis\/\">\u00fcst\u00fc \u00e7izili \u00e7izgi uygulamak<\/a> istedi\u011finizi varsayal\u0131m, bu zaman kodu \u015f\u00f6yle olacakt\u0131r:<\/p><p> Dedi\u011fim gibi kullanabilece\u011finiz toplam 18 farkl\u0131 \u00f6zellik var, hangisinin i\u015finize yarad\u0131\u011f\u0131n\u0131 g\u00f6rmek i\u00e7in hepsini kontrol etti\u011finizden emin olun.<\/p><h3 class=\"wp-block-heading\"> 5. H\u00fccredeki bi\u00e7imlendirmeyi temizleyin<\/h3><p> \u201c.ClearFormats\u201d y\u00f6ntemini kullanarak yaln\u0131zca bir h\u00fccrenin veya h\u00fccre aral\u0131\u011f\u0131n\u0131n bi\u00e7imini temizleyebilirsiniz. Tek yapman\u0131z gereken a\u015fa\u011f\u0131daki gibi aral\u0131\u011f\u0131 belirledikten sonra \u201c.ClearFormat\u201d\u0131 eklemek:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").ClearFormats<\/code><\/pre><p> Yukar\u0131daki kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, A1 h\u00fccresindeki t\u00fcm bi\u00e7imlendirmeler temizlenir ve bunu t\u00fcm aral\u0131k i\u00e7in yapmak istiyorsan\u0131z ne yapman\u0131z gerekti\u011fini biliyorsunuz, de\u011fil mi?<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A5\").ClearFormats<\/code><\/pre><p> \u015eimdi yukar\u0131daki kod A1 ila A5 aral\u0131\u011f\u0131ndaki format\u0131 kald\u0131racakt\u0131r.<\/p><h2 class=\"wp-block-heading\"> H\u00fccre \u00f6zelli\u011fi<\/h2><p> ARALIK \u00f6zelli\u011fine ek olarak, \u00e7al\u0131\u015fma sayfan\u0131zdaki bir h\u00fccreye veya h\u00fccre aral\u0131\u011f\u0131na ba\u015fvurmak i\u00e7in &#8220;H\u00fccreler&#8221; \u00f6zelli\u011fini kullanabilirsiniz. H\u00fccre \u00f6zelli\u011finde h\u00fccre referans\u0131n\u0131 kullanmak yerine h\u00fccrenin s\u00fctun numaras\u0131n\u0131 ve sat\u0131r numaras\u0131n\u0131 girmeniz gerekir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">expression.Cells(Row_Number, Column_Number)<\/code><\/pre><p> Burada ifade bir VBA nesnesidir ve Row_Number h\u00fccrenin sat\u0131r numaras\u0131d\u0131r ve Column_Number h\u00fccrenin s\u00fctunudur. Yani A5 h\u00fccresine ba\u015fvurmak istiyorsan\u0131z a\u015fa\u011f\u0131daki kodu kullanabilirsiniz:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Cells(5,1)<\/code><\/pre><p> \u015eimdi bu kod, VBA&#8217;ya be\u015finci sat\u0131r ve bir numaral\u0131 s\u00fctundaki h\u00fccreye ba\u015fvurmas\u0131n\u0131 s\u00f6yler. S\u00f6zdiziminin \u00f6nerdi\u011fi gibi, adres olarak s\u00fctun numaras\u0131n\u0131 girmeniz gerekir, ancak ger\u00e7ek \u015fu ki, isterseniz s\u00fctun alfabesini yaln\u0131zca \u00e7ift t\u0131rnak i\u015fareti i\u00e7ine alarak da kullanabilirsiniz.<\/p><p> A\u015fa\u011f\u0131daki kod ayn\u0131 zamanda A5 h\u00fccresine de at\u0131fta bulunacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Cells(5,\"A\")<\/code><\/pre><p> Ve VBA&#8217;da bunu se\u00e7mek i\u00e7in sonuna &#8220;.Select&#8221; eklemeniz yeterlidir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Cells(5,1).Select<\/code><\/pre><p> Yukar\u0131daki kod, \u00e7al\u0131\u015fma sayfas\u0131n\u0131n 5. sat\u0131r\u0131nda ve ilk s\u00fctununda bulunan A5 h\u00fccresini se\u00e7ecektir.<\/p><h2 class=\"wp-block-heading\"> OFFSET \u00d6zelli\u011fi<\/h2><p> VBA&#8217;da aral\u0131klarla iyi oynamak istiyorsan\u0131z OFFSET \u00f6zelli\u011fini nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 bilmeniz gerekir. Ba\u015fka bir h\u00fccreden belirli say\u0131da sat\u0131r ve s\u00fctun uzakta olan bir h\u00fccreyi belirtmekte fayda vard\u0131r.<\/p><p> Diyelim ki \u015fu anda aktif olan h\u00fccreniz B5 ve B5&#8217;in 3 s\u00fctun sa\u011f\u0131nda ve 1 s\u0131ra a\u015fa\u011f\u0131s\u0131ndaki h\u00fccreye gitmek istiyorsan\u0131z SHIFT&#8217;i yapabilirsiniz. OFFSET i\u00e7in kullanman\u0131z gereken s\u00f6z dizimi a\u015fa\u011f\u0131dad\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">expression.Offset (RowOffset, ColumnOffset)<\/code><\/pre><ul><li> <strong>RowOffset:<\/strong> Bu arg\u00fcmanda VBA&#8217;ya ka\u00e7 sat\u0131rdan ge\u00e7mek istedi\u011finizi s\u00f6yleyecek bir say\u0131 belirtmeniz gerekir. Pozitif bir say\u0131 a\u015fa\u011f\u0131 do\u011fru bir sat\u0131r\u0131, negatif bir say\u0131 ise yukar\u0131 do\u011fru bir sat\u0131r\u0131 tan\u0131mlar.<\/li><li> <strong>ColumnOffset<\/strong> : Bu ba\u011f\u0131ms\u0131z de\u011fi\u015fkende, VBA&#8217;ya ka\u00e7 s\u00fctunda gezinmek istedi\u011finizi s\u00f6yleyecek bir say\u0131 belirtmeniz gerekir. Pozitif bir say\u0131 sa\u011f s\u00fctunu, negatif say\u0131 ise sol s\u00fctunu tan\u0131mlar.<\/li><\/ul><p> \u00d6rnek olarak yukar\u0131da bahsetti\u011fimiz basit bir kod yazal\u0131m.<\/p><ol><li> \u00d6ncelikle gezinmek istedi\u011finiz aral\u0131\u011f\u0131 tan\u0131mlaman\u0131z ve b\u00f6ylece a\u015fa\u011f\u0131daki kodu yazman\u0131z gerekir: <br><img loading=\"lazy\" decoding=\"async\" title=\"1-aral\u0131\u011f\u0131-tan\u0131mla\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-definir-la-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"define-the-range\" width=\"399\" height=\"157\"><\/li><li> Bundan sonra \u201c.Offset\u201d yaz\u0131n ve a\u015fa\u011f\u0131daki gibi a\u00e7\u0131l\u0131\u015f parantezlerini girin: <br><img loading=\"lazy\" decoding=\"async\" title=\"Tip 2 ofset\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-types-de-decalage.png\" sizes=\"auto, \" srcset=\"\" alt=\"type-offset\" width=\"402\" height=\"148\"><\/li><li> Daha sonra, gitmek istedi\u011finiz sat\u0131r numaras\u0131n\u0131 ve ard\u0131ndan s\u00fctun numaras\u0131n\u0131 girmeniz gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-sat\u0131r ve s\u00fctun say\u0131s\u0131n\u0131 girin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrez-le-numero-de-ligne-et-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-row-and-column number\" width=\"398\" height=\"167\"><\/li><li> VBA&#8217;ya gitmek istedi\u011finiz h\u00fccreyi se\u00e7mesini s\u00f6ylemek i\u00e7in sonuna &#8220;.Select&#8221; eklemeniz gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-s\u00f6ylemek i\u00e7in se\u00e7-vba ekleme\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ajouter-selectionner-pour-dire-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-select-to-tell-vba\" width=\"394\" height=\"153\"><\/li><\/ol><p> Yani bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda B5 h\u00fccresinin bir sat\u0131r a\u015fa\u011f\u0131s\u0131nda ve 3 s\u00fctun sa\u011f\u0131ndaki h\u00fccreyi se\u00e7iyor.<\/p><h3 class=\"wp-block-heading\"> OFFSET kullanarak bir aral\u0131\u011f\u0131 yeniden boyutland\u0131rma<\/h3><p> OFFSET yaln\u0131zca bir h\u00fccreye gitmenize olanak sa\u011flamakla kalmaz, ayn\u0131 zamanda aral\u0131\u011f\u0131 daha da yeniden boyutland\u0131rabilirsiniz. Yukar\u0131daki \u00f6rnekle devam edelim.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"B5\").Offset(1, 3).Select<\/code><\/pre><p> Yukar\u0131daki kod sizi E6 h\u00fccresine y\u00f6nlendiriyor ve \u015fimdi diyelim ki E6&#8217;n\u0131n be\u015f s\u00fctun ve \u00fc\u00e7 sat\u0131r\u0131ndan olu\u015fan h\u00fccre aral\u0131\u011f\u0131n\u0131 se\u00e7meniz gerekiyor. Yani yapman\u0131z gereken OFFSET kulland\u0131ktan sonra resize \u00f6zelli\u011fini \u201c.Resize\u201d ekleyerek kullanmak.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"B5\").Offset(1, 3).Resize<\/code><\/pre><p> \u015eimdi sat\u0131r boyutunu ve s\u00fctun boyutunu girmeniz gerekiyor. \u00d6nde bir parantez yaz\u0131n ve sat\u0131r boyutunu ayarlamak i\u00e7in say\u0131y\u0131, ard\u0131ndan s\u00fctun boyutunu ayarlamak i\u00e7in bir say\u0131 girin.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"B5\").Offset(1, 3).Resize(3,5)<\/code><\/pre><p> Sonuna &#8220;.Select&#8221; ekleyerek VBA&#8217;ya aral\u0131\u011f\u0131 se\u00e7mesini s\u00f6yleyin; bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda aral\u0131\u011f\u0131 se\u00e7ecektir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"B5\").Offset(1, 3).Resize(3, 5).Select<\/code><\/pre><p> Yani bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda E6 ila I8 aral\u0131\u011f\u0131n\u0131 se\u00e7ecektir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Font.Strikethrough = True<\/code><\/pre>","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-2051","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&#039;da aral\u0131k ve h\u00fccreler nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Excel aral\u0131k nesnesi ve VBA&#039;da bir aral\u0131\u011fa veya h\u00fccreye ba\u015fvurmak i\u00e7in kullanabilece\u011finiz t\u00fcm yollar hakk\u0131nda bilgi edinin.\" \/>\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\/aralik-1\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA&#039;da aral\u0131k ve h\u00fccreler nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Excel aral\u0131k nesnesi ve VBA&#039;da bir aral\u0131\u011fa veya h\u00fccreye ba\u015fvurmak i\u00e7in kullanabilece\u011finiz t\u00fcm yollar hakk\u0131nda bilgi edinin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/aralik-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-definir-la-gamme.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=\"11 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aralik-1\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/aralik-1\/\",\"name\":\"VBA&#39;da aral\u0131k ve h\u00fccreler nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aralik-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aralik-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-definir-la-gamme.png\",\"datePublished\":\"2023-10-22T17:02:51+00:00\",\"dateModified\":\"2023-12-10T06:07:27+00:00\",\"description\":\"Excel aral\u0131k nesnesi ve VBA&#39;da bir aral\u0131\u011fa veya h\u00fccreye ba\u015fvurmak i\u00e7in kullanabilece\u011finiz t\u00fcm yollar hakk\u0131nda bilgi edinin.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/aralik-1\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/aralik-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aralik-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-definir-la-gamme.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-definir-la-gamme.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/aralik-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba&#39;da aral\u0131k ve h\u00fccreler nas\u0131l kullan\u0131l\u0131r?\"}]},{\"@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&#39;da aral\u0131k ve h\u00fccreler nas\u0131l kullan\u0131l\u0131r?","description":"Excel aral\u0131k nesnesi ve VBA&#39;da bir aral\u0131\u011fa veya h\u00fccreye ba\u015fvurmak i\u00e7in kullanabilece\u011finiz t\u00fcm yollar hakk\u0131nda bilgi edinin.","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\/aralik-1\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA&#39;da aral\u0131k ve h\u00fccreler nas\u0131l kullan\u0131l\u0131r?","og_description":"Excel aral\u0131k nesnesi ve VBA&#39;da bir aral\u0131\u011fa veya h\u00fccreye ba\u015fvurmak i\u00e7in kullanabilece\u011finiz t\u00fcm yollar hakk\u0131nda bilgi edinin.","og_url":"https:\/\/exceladvisor.org\/tr\/aralik-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-definir-la-gamme.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"11 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/aralik-1\/","url":"https:\/\/exceladvisor.org\/tr\/aralik-1\/","name":"VBA&#39;da aral\u0131k ve h\u00fccreler nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/aralik-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/aralik-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-definir-la-gamme.png","datePublished":"2023-10-22T17:02:51+00:00","dateModified":"2023-12-10T06:07:27+00:00","description":"Excel aral\u0131k nesnesi ve VBA&#39;da bir aral\u0131\u011fa veya h\u00fccreye ba\u015fvurmak i\u00e7in kullanabilece\u011finiz t\u00fcm yollar hakk\u0131nda bilgi edinin.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/aralik-1\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/aralik-1\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/aralik-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-definir-la-gamme.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-definir-la-gamme.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/aralik-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba&#39;da aral\u0131k ve h\u00fccreler nas\u0131l kullan\u0131l\u0131r?"}]},{"@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\/2051","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=2051"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2051\/revisions"}],"predecessor-version":[{"id":2931,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2051\/revisions\/2931"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}