{"id":1600,"date":"2023-11-15T14:02:58","date_gmt":"2023-11-15T14:02:58","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/birlestirmek\/"},"modified":"2023-12-10T06:06:08","modified_gmt":"2023-12-10T06:06:08","slug":"birlestirmek","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/birlestirmek\/","title":{"rendered":"Vba kodunu kullanarak excel&#39;deki h\u00fccreleri birle\u015ftirme"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1575926613\"><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>VBA&#8217;da, <strong>bir h\u00fccre aral\u0131\u011f\u0131n\u0131, hatta birden fazla aral\u0131\u011f\u0131 tek bir h\u00fccrede birle\u015ftirmek<\/strong> i\u00e7in kullanabilece\u011finiz bir &#8220;B\u0130RLE\u015eT\u0130RME&#8221; y\u00f6ntemi vard\u0131r. Bu y\u00f6ntemin iste\u011fe ba\u011fl\u0131 bir &#8220;Across&#8221; arg\u00fcman\u0131 vard\u0131r. TRUE belirtirseniz aral\u0131ktaki her sat\u0131r\u0131 ayr\u0131 ayr\u0131 birle\u015ftirir, FALSE belirtirseniz t\u00fcm aral\u0131\u011f\u0131 tek bir sat\u0131rda birle\u015ftirir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52303\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fusionner-et-dissocier-des-cellules-a-laide-de-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba kullanarak h\u00fccreleri birle\u015ftirme ve gruplar\u0131n\u0131 \u00e7\u00f6zme\" width=\"637\" height=\"74\"><\/figure><\/div><p> <strong>H\u00fccreleri birle\u015ftirmek i\u00e7in VBA&#8217;y\u0131 kullanma ad\u0131mlar\u0131:<\/strong><\/p><ol><li> \u00d6ncelikle birle\u015ftirmek istedi\u011finiz h\u00fccre aral\u0131\u011f\u0131n\u0131 tan\u0131mlaman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-bir h\u00fccrenin birle\u015ftirmek istedi\u011fi aral\u0131\u011f\u0131n\u0131 tan\u0131mlay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-definir-la-plage-dune-cellule-que-vous-souhaitez-fusionner.png\" sizes=\"auto, \" srcset=\"\" alt=\"define-the-range-of-a-cell-want-to-merge\" width=\"291\" height=\"220\"><\/li><li> Bundan sonra, \u00f6zellik ve y\u00f6ntemlerin listesini almak i\u00e7in bir nokta (.) yaz\u0131n ve bu listeden \u201cBirle\u015ftir\u201d se\u00e7ene\u011fini se\u00e7in veya do\u011frudan yazabilirsiniz. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-tip-\u00f6zellik-listesi-al\u0131nacak d\u00f6nem\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-tapez-un-point-pour-obtenir-la-liste-des-proprietes.png\" sizes=\"auto, \" srcset=\"\" alt=\"type-a-dot-to-get-the-list-of-properties\" width=\"338\" height=\"198\"><\/li><li> Bundan sonra \u201cAcross\u201d arg\u00fcman\u0131n\u0131 DO\u011eRU veya YANLI\u015e olarak ayarlaman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"4'l\u00fc arg\u00fcman her yerde\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-definir-largument-a-travers.png\" sizes=\"auto, \" srcset=\"\" alt=\"define-the-argument-across\" width=\"365\" height=\"177\"><\/li><li> Sonunda aral\u0131\u011f\u0131 birle\u015ftirmek i\u00e7in bu kodu \u00e7al\u0131\u015ft\u0131r\u0131n.<\/li><\/ol><p> \u0130\u015fte kod.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A2\").Merge False<\/code><\/pre><p> Ve aral\u0131\u011f\u0131n tamam\u0131ndaki sat\u0131rlar\u0131 birle\u015ftirmek istiyorsan\u0131z \u00e7apraz ba\u011f\u0131ms\u0131z de\u011fi\u015fkeni i\u00e7in TRUE&#8217;yu kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52307\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-tapez-true-si-vous-souhaitez-fusionner-sur-toute-la-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"aral\u0131kta birle\u015ftirmek istiyorsan\u0131z do\u011fru yaz\u0131n\" width=\"657\" height=\"283\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Selection.Merge Across:=True<\/code><\/pre><p> Yukar\u0131daki kodda aral\u0131k olarak, birle\u015ftirme y\u00f6ntemi olarak ve genelinde do\u011fru olarak se\u00e7im yapt\u0131n\u0131z. Ve se\u00e7ilen aral\u0131ktaki t\u00fcm sat\u0131rlar\u0131 birle\u015ftirdi.<\/p><p> \u015eimdi diyelim ki ba\u015fka bir \u00e7al\u0131\u015fma sayfas\u0131ndaki h\u00fccre aral\u0131\u011f\u0131n\u0131 birle\u015ftirmek istiyorsunuz, \u00f6nce bunu etkinle\u015ftirmenize gerek yok. \u00d6nce e-tabloya ba\u015fvurabilir ve ard\u0131ndan birle\u015ftirmek istedi\u011finiz de\u011fi\u015fiklikle birle\u015ftirme y\u00f6ntemlerini kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\"Sheet1\").Range(\"A1:A2\").Merge<\/code><\/pre><p> Benzer \u015fekilde, \u00e7al\u0131\u015fma kitab\u0131n\u0131n ad\u0131n\u0131 belirterek bir \u00e7al\u0131\u015fma kitab\u0131na da ba\u015fvurabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Workbooks(\"Book1.xlsx\").Worksheets(\"Sheet1\").Range(\"A1:A2\").Merge<\/code><\/pre><h2 class=\"wp-block-heading\"> Bir aral\u0131\u011f\u0131 birle\u015ftirme ve h\u00fccre i\u00e7eri\u011fini hizalama<\/h2><p> Art\u0131k iki veya daha fazla h\u00fccreyi birle\u015ftirdi\u011finizde h\u00fccredeki i\u00e7eri\u011fi hizalaman\u0131z gerekir. A1 ve A2 h\u00fccrelerini birle\u015ftirdi\u011finiz ve h\u00fccrelerdeki de\u011ferin alta hizaland\u0131\u011f\u0131 a\u015fa\u011f\u0131daki anl\u0131k g\u00f6r\u00fcnt\u00fcye bak\u0131n. Bu sorunu \u00e7\u00f6zmek i\u00e7in hizalama \u00f6zelli\u011fini kullanabilir ve h\u00fccre i\u00e7eri\u011fini ortaya ve ortaya hizalayarak okuman\u0131z\u0131 kolayla\u015ft\u0131rabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52308\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-fusionner-une-plage-et-aligner-le-contenu-de-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"bir aral\u0131\u011f\u0131 birle\u015ftirme ve h\u00fccre i\u00e7eri\u011fini hizalama\" width=\"551\" height=\"450\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">With Range(\"A1:A2\") .Merge .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With<\/code><\/pre><h2 class=\"wp-block-heading\"> Metni birle\u015ftir ve birle\u015ftir<\/h2><p> Ger\u00e7ek hayattan bir senaryodan bahsedelim. Bir dizi h\u00fccrede metniniz var ve bu h\u00fccreleri birle\u015ftirmeniz gerekiyor, ancak sahip oldu\u011funuz i\u00e7eri\u011fi kaybetmek istemezsiniz. Her birini kullanarak t\u00fcm aral\u0131\u011f\u0131n \u00fczerine bir kod d\u00f6ng\u00fcs\u00fc yazabilir ve metni birle\u015ftirip ard\u0131ndan onu sondaki birle\u015ftirilmi\u015f aral\u0131\u011fa ekleyebilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-52309\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-combiner-le-test-et-fusionner.png\" sizes=\"auto, \" srcset=\"\" alt=\"birle\u015ftir-test et ve birle\u015ftir\" width=\"512\" height=\"588\"><\/figure><\/div><ol><li> \u0130lk b\u00f6l\u00fcmde aral\u0131k de\u011ferlerini saklamak ve kendilerini ayarlamak i\u00e7in kullanabilece\u011finiz de\u011fi\u015fkenler bulunuyor.<\/li><li> \u0130kinci b\u00f6l\u00fcmde, her h\u00fccrenin de\u011ferlerini birle\u015ftirerek yeni bir dize olu\u015fturabilece\u011finiz bir LOOP&#8217;unuz var.<\/li><li> \u00dc\u00e7\u00fcnc\u00fc b\u00f6l\u00fcmde aral\u0131\u011f\u0131 birle\u015ftirin, birle\u015ftirilmi\u015f dizeyi ekleyin, s\u00f6zc\u00fck kayd\u0131rma uygulay\u0131n ve h\u00fccre i\u00e7eri\u011fini hizalay\u0131n.<\/li><\/ol><p> \u0130\u015fte kodun tamam\u0131.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_merge_with_values() Dim val As String Dim rng As Range Set rng = Range(\"A1:A10\") For Each Cell In rng val = val &amp; \" \" &amp; Cell.Value Next Cell With rng .Merge .Value = Trim(val) .WrapText = True .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With End Sub<\/code><\/pre><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\/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\/aralik-1\/\">Excel VBA Aral\u0131\u011f\u0131 \u2013 Aral\u0131k ve H\u00fccrelerle \u00c7al\u0131\u015fmak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sinirlar\/\">Excel&#8217;de VBA kullanarak h\u00fccreye kenarl\u0131klar uygulama<\/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-1600","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 kodunu kullanarak Excel&#039;deki h\u00fccreleri birle\u015ftirme<\/title>\n<meta name=\"description\" content=\"Burada h\u00fccreleri birle\u015ftirmek i\u00e7in VBA&#039;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz (hatta birden fazla aral\u0131\u011f\u0131 tek bir aral\u0131kta toplay\u0131n ve de\u011feri merkeze hizalay\u0131n).\" \/>\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\/birlestirmek\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA kodunu kullanarak Excel&#039;deki h\u00fccreleri birle\u015ftirme\" \/>\n<meta property=\"og:description\" content=\"Burada h\u00fccreleri birle\u015ftirmek i\u00e7in VBA&#039;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz (hatta birden fazla aral\u0131\u011f\u0131 tek bir aral\u0131kta toplay\u0131n ve de\u011feri merkeze hizalay\u0131n).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:06:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fusionner-et-dissocier-des-cellules-a-laide-de-vba.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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/\",\"name\":\"VBA kodunu kullanarak Excel&#39;deki h\u00fccreleri birle\u015ftirme\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fusionner-et-dissocier-des-cellules-a-laide-de-vba.png\",\"datePublished\":\"2023-11-15T14:02:58+00:00\",\"dateModified\":\"2023-12-10T06:06:08+00:00\",\"description\":\"Burada h\u00fccreleri birle\u015ftirmek i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz (hatta birden fazla aral\u0131\u011f\u0131 tek bir aral\u0131kta toplay\u0131n ve de\u011feri merkeze hizalay\u0131n).\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fusionner-et-dissocier-des-cellules-a-laide-de-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fusionner-et-dissocier-des-cellules-a-laide-de-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/birlestirmek\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba kodunu kullanarak excel&#39;deki h\u00fccreleri birle\u015ftirme\"}]},{\"@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 kodunu kullanarak Excel&#39;deki h\u00fccreleri birle\u015ftirme","description":"Burada h\u00fccreleri birle\u015ftirmek i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz (hatta birden fazla aral\u0131\u011f\u0131 tek bir aral\u0131kta toplay\u0131n ve de\u011feri merkeze hizalay\u0131n).","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\/birlestirmek\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA kodunu kullanarak Excel&#39;deki h\u00fccreleri birle\u015ftirme","og_description":"Burada h\u00fccreleri birle\u015ftirmek i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz (hatta birden fazla aral\u0131\u011f\u0131 tek bir aral\u0131kta toplay\u0131n ve de\u011feri merkeze hizalay\u0131n).","og_url":"https:\/\/exceladvisor.org\/tr\/birlestirmek\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:06:08+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fusionner-et-dissocier-des-cellules-a-laide-de-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/birlestirmek\/","url":"https:\/\/exceladvisor.org\/tr\/birlestirmek\/","name":"VBA kodunu kullanarak Excel&#39;deki h\u00fccreleri birle\u015ftirme","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/birlestirmek\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/birlestirmek\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fusionner-et-dissocier-des-cellules-a-laide-de-vba.png","datePublished":"2023-11-15T14:02:58+00:00","dateModified":"2023-12-10T06:06:08+00:00","description":"Burada h\u00fccreleri birle\u015ftirmek i\u00e7in VBA&#39;y\u0131 nas\u0131l kullanaca\u011f\u0131n\u0131z\u0131 \u00f6\u011freneceksiniz (hatta birden fazla aral\u0131\u011f\u0131 tek bir aral\u0131kta toplay\u0131n ve de\u011feri merkeze hizalay\u0131n).","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/birlestirmek\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/birlestirmek\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/birlestirmek\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fusionner-et-dissocier-des-cellules-a-laide-de-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fusionner-et-dissocier-des-cellules-a-laide-de-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/birlestirmek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba kodunu kullanarak excel&#39;deki h\u00fccreleri birle\u015ftirme"}]},{"@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\/1600","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=1600"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1600\/revisions"}],"predecessor-version":[{"id":2852,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1600\/revisions\/2852"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}