{"id":1525,"date":"2023-11-17T21:24:59","date_gmt":"2023-11-17T21:24:59","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/"},"modified":"2023-12-10T06:04:50","modified_gmt":"2023-12-10T06:04:50","slug":"yeni-bir-deger-dizisi-ekle","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/","title":{"rendered":"Vba arac\u0131l\u0131\u011f\u0131yla bir diziye yeni bir de\u011fer nas\u0131l eklenir?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-160407038\"><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>Mevcut bir diziye yeni bir de\u011fer eklemek i\u00e7in elemanlar\u0131n\u0131 yeniden tan\u0131mlayacak dinamik bir diziye sahip olman\u0131z gerekir ve bunu yapt\u0131\u011f\u0131n\u0131zda eski elemanlar\u0131n de\u011ferlerini koruman\u0131z gerekir. Bu, tan\u0131mlad\u0131\u011f\u0131n\u0131z yeni \u00f6\u011feye yaln\u0131zca de\u011feri eklemenize ve par\u00e7an\u0131n geri kalan\u0131n\u0131 oldu\u011fu gibi b\u0131rakman\u0131za yard\u0131mc\u0131 olur.<\/p><p> A\u015fa\u011f\u0131da iki \u00f6\u011feyi tan\u0131mlad\u0131\u011f\u0131n\u0131z bir diziniz var. Bu dinamik bir dizi oldu\u011fundan, iki \u00f6\u011feyi tan\u0131mlamak ve ard\u0131ndan bu \u00f6\u011felere de\u011fer eklemek i\u00e7in bir &#8220;ReDim&#8221; ifadesine sahipsiniz. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57215\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-pour-redefinir-les-elements-1-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00f6\u011feleri yeniden tan\u0131mlamak i\u00e7in dinamik dizi\" width=\"497\" height=\"359\"><\/figure><\/div><p> Daha sonra bu diziye \u00fc\u00e7\u00fcnc\u00fc bir \u00f6\u011fe ekleyece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> <strong>VBA&#8217;da bir diziye yeni bir de\u011fer ekleyin<\/strong><\/h2><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57216\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-ajouter-une-nouvelle-valeur-a-un-tableau-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"505\" height=\"564\"><\/figure><\/div><ol type=\"1\"><li> \u00d6ncelikle, de\u011ferini eklemek istedi\u011finiz yeni \u00f6\u011fe de dahil olmak \u00fczere her iki \u00f6\u011feyi de korumak i\u00e7in &#8220;Preserve&#8221; anahtar s\u00f6zc\u00fc\u011f\u00fcyle birlikte &#8220;ReDim&#8221; ifadesini kullanman\u0131z gerekir.<\/li><li> Daha sonra dizide olmas\u0131n\u0131 istedi\u011finiz elemanlar\u0131 tan\u0131mlaman\u0131z gerekir. Burada \u00fc\u00e7 elemente sahip olman\u0131z gerekiyor, bu y\u00fczden bunun i\u00e7in 1&#8217;den 3&#8217;e kadar olan say\u0131lar\u0131 kullan\u0131yoruz.<\/li><li> Daha sonra yeni tan\u0131mlad\u0131\u011f\u0131n\u0131z element olan \u00fc\u00e7\u00fcnc\u00fc elemente de\u011fer katman\u0131z gerekiyor.<\/li><li> Sonunda, yeni \u00f6\u011felerle birlikte t\u00fcm \u00f6\u011feleri hemen pencerede almak i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/aninda-pencere-hata-ayiklama-baskisi\/\">debug.print&#8217;i<\/a> kullan\u0131n.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Explicit Option Base 1 Sub vba_array_add_value() Dim myArray() As Variant ReDim myArray(2) myArray(1) = 5 myArray(2) = 10 ReDim Preserve myArray(1 To 3) myArray(3) = 15 Debug.Print myArray(1) Debug.Print myArray(2) Debug.Print myArray(3) End Sub<\/code><\/pre><p> Birka\u00e7 kelimeyi daha sizinle payla\u015fay\u0131m.<\/p><ul><li> Daha sonra koddaki diziye daha fazla de\u011fer eklemeniz gerekti\u011fini biliyorsan\u0131z, diziyi ba\u015flang\u0131\u00e7ta dinamik dizi olarak bildirmelisiniz.<\/li><li> Bu y\u00f6ntemi kullanarak yaln\u0131zca dizinin sonuna yeni bir \u00f6\u011fe ekleyebilirsiniz.<\/li><\/ul><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\"> <a href=\"https:\/\/exceladvisor.org\/tr\/resim-sergisi\/\">VBA tablolar\u0131<\/a> hakk\u0131nda daha fazla bilgi edinin <\/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\/dizi-boyutu\/\">VBA dizisi uzunlu\u011fu (boyut)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/zincirli-masa\/\">Dizelerle VBA dizisi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/tahtayi-sil\/\">VBA Diziyi Temizle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/dinamik-tablo\/\">Dinamik tablo VBA&#8217;s\u0131<\/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\/vba-dongu-dizisi\/\">Bir dizideki VBA d\u00f6ng\u00fcs\u00fc<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/cok-boyutlu-dizi\/\">\u00c7ok boyutlu dizi VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/plajin-bir-tablosu-var\/\">Bir diziye VBA aral\u0131\u011f\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/siralama-tablosu\/\">VBA \u00e7\u0131kt\u0131 tablosu<\/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-1525","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 arac\u0131l\u0131\u011f\u0131yla bir diziye yeni bir de\u011fer nas\u0131l eklenir?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde VBA&#039;da bir diziye nas\u0131l yeni de\u011fer eklenece\u011fini \u00f6\u011freneceksiniz. De\u011feri sahip oldu\u011funuz yeni \u00f6\u011feye ekleyin\" \/>\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\/yeni-bir-deger-dizisi-ekle\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA arac\u0131l\u0131\u011f\u0131yla bir diziye yeni bir de\u011fer nas\u0131l eklenir?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde VBA&#039;da bir diziye nas\u0131l yeni de\u011fer eklenece\u011fini \u00f6\u011freneceksiniz. De\u011feri sahip oldu\u011funuz yeni \u00f6\u011feye ekleyin\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-pour-redefinir-les-elements-1-2.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\/yeni-bir-deger-dizisi-ekle\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/\",\"name\":\"VBA arac\u0131l\u0131\u011f\u0131yla bir diziye yeni bir de\u011fer nas\u0131l eklenir?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-pour-redefinir-les-elements-1-2.png\",\"datePublished\":\"2023-11-17T21:24:59+00:00\",\"dateModified\":\"2023-12-10T06:04:50+00:00\",\"description\":\"Bu e\u011fitimde VBA&#39;da bir diziye nas\u0131l yeni de\u011fer eklenece\u011fini \u00f6\u011freneceksiniz. De\u011feri sahip oldu\u011funuz yeni \u00f6\u011feye ekleyin\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-pour-redefinir-les-elements-1-2.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-pour-redefinir-les-elements-1-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba arac\u0131l\u0131\u011f\u0131yla bir diziye yeni bir de\u011fer nas\u0131l eklenir?\"}]},{\"@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 arac\u0131l\u0131\u011f\u0131yla bir diziye yeni bir de\u011fer nas\u0131l eklenir?","description":"Bu e\u011fitimde VBA&#39;da bir diziye nas\u0131l yeni de\u011fer eklenece\u011fini \u00f6\u011freneceksiniz. De\u011feri sahip oldu\u011funuz yeni \u00f6\u011feye ekleyin","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\/yeni-bir-deger-dizisi-ekle\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA arac\u0131l\u0131\u011f\u0131yla bir diziye yeni bir de\u011fer nas\u0131l eklenir?","og_description":"Bu e\u011fitimde VBA&#39;da bir diziye nas\u0131l yeni de\u011fer eklenece\u011fini \u00f6\u011freneceksiniz. De\u011feri sahip oldu\u011funuz yeni \u00f6\u011feye ekleyin","og_url":"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:50+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-pour-redefinir-les-elements-1-2.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\/yeni-bir-deger-dizisi-ekle\/","url":"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/","name":"VBA arac\u0131l\u0131\u011f\u0131yla bir diziye yeni bir de\u011fer nas\u0131l eklenir?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-pour-redefinir-les-elements-1-2.png","datePublished":"2023-11-17T21:24:59+00:00","dateModified":"2023-12-10T06:04:50+00:00","description":"Bu e\u011fitimde VBA&#39;da bir diziye nas\u0131l yeni de\u011fer eklenece\u011fini \u00f6\u011freneceksiniz. De\u011feri sahip oldu\u011funuz yeni \u00f6\u011feye ekleyin","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-pour-redefinir-les-elements-1-2.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-tableau-dynamique-pour-redefinir-les-elements-1-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-deger-dizisi-ekle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba arac\u0131l\u0131\u011f\u0131yla bir diziye yeni bir de\u011fer nas\u0131l eklenir?"}]},{"@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\/1525","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=1525"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1525\/revisions"}],"predecessor-version":[{"id":2766,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1525\/revisions\/2766"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}