{"id":2210,"date":"2023-09-01T07:18:23","date_gmt":"2023-09-01T07:18:23","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/sinirlar\/"},"modified":"2023-12-10T06:04:10","modified_gmt":"2023-12-10T06:04:10","slug":"sinirlar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/sinirlar\/","title":{"rendered":"H\u00fccreye kenarl\u0131klar nas\u0131l uygulan\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3008797939\"><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>Excel&#8217;de VBA kullanarak bir h\u00fccreye kenarl\u0131k uygulamak i\u00e7in iki farkl\u0131 y\u00f6ntem kullanabilirsiniz. Birincisi \u201cBorders\u201d \u00f6zelli\u011fi, ikincisi ise \u201cBorderAround\u201d y\u00f6ntemidir. Bu iki y\u00f6ntem aras\u0131ndaki tek fark \u201cBorders\u201d \u00f6zelli\u011finde, hatta h\u00fccrenin bir taraf\u0131na kenarl\u0131k uygulayabiliyorsunuz ve etraf\u0131ndaki kenarl\u0131k da tamamen h\u00fccreye uygulan\u0131yor.<\/p><p> Bu derste her iki yolu da ke\u015ffedece\u011fiz ve kenarl\u0131k eklemenin farkl\u0131 yollar\u0131n\u0131n neler oldu\u011funa bakaca\u011f\u0131z.<\/p><h2 class=\"wp-block-heading\"> VBA s\u0131n\u0131r \u00f6zelli\u011fi<\/h2><ol><li> \u00d6ncelikle aral\u0131k nesnesini kullanarak kenarl\u0131\u011f\u0131 uygulamak istedi\u011finiz aral\u0131\u011f\u0131 veya h\u00fccreyi belirtmeniz gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-aral\u0131\u011f\u0131-veya-h\u00fccreyi belirtin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-specifier-la-plage-ou-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"specify the range or cell\" width=\"371\" height=\"247\"><\/li><li> Bundan sonra bir nokta (.) yaz\u0131n ve ard\u0131ndan \u00f6zellikler ve y\u00f6ntemler listesinden \u201cKenarl\u0131klar\u201d \u00f6zelli\u011fini se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-bir nokta yaz\u0131n ve ard\u0131ndan kenarl\u0131\u011f\u0131 se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-tapez-un-point-puis-selectionnez-la-bordure.png\" sizes=\"auto, \" srcset=\"\" alt=\"type a dot and then select the border\" width=\"384\" height=\"315\"><\/li><li> Daha sonra mevcut i\u00e7eriklerden kenarl\u0131k indeksini belirtin. Burada kenarl\u0131\u011f\u0131 yaln\u0131zca h\u00fccrenin alt\u0131na uygulamak i\u00e7in \u201cxlEdgeBottom\u201d kullan\u0131yorum. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-indeks-kenarl\u0131\u011f\u0131n\u0131 belirtin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-specifier-lindex-de-bordure.png\" sizes=\"auto, \" srcset=\"\" alt=\"specify the border index\" width=\"408\" height=\"265\"><\/li><li> Oradan \u201cLineStyle\u201d\u0131 kullanarak \u00e7izgi stilini belirtin. \u00c7izgi stili olarak &#8220;xlContinuonus&#8221; kullan\u0131yorum. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-sat\u0131r stilini belirtin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-specifier-le-style-de-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"specify th line style\" width=\"532\" height=\"201\"><\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_borders() Range(\"A1\") _ .Borders(xlEdgeBottom) _ .LineStyle = XlLineStyle.xlContinuous End Sub<\/code><\/pre><p> \u015eimdi bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda A1 h\u00fccresinin alt\u0131na bir kenarl\u0131k ekleyecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54776\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-il-ajoutera-une-bordure-en-bas.png\" sizes=\"auto, \" srcset=\"\" alt=\"bu alt tarafa bir kenarl\u0131k ekleyecektir\" width=\"544\" height=\"238\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Renk Dizini\/Renk ile farkl\u0131 renkler kullanma<\/h2><p> T\u0131pk\u0131 normalde manuel olarak yapt\u0131\u011f\u0131n\u0131zda kenarl\u0131k rengini se\u00e7ti\u011finiz gibi. Border \u00f6zelli\u011finde, varsay\u0131lan renk d\u0131\u015f\u0131nda bir renk kullanmak i\u00e7in renk indeksini ve color \u00f6zelli\u011fini de kullanabilirsiniz.<\/p><p> A\u015fa\u011f\u0131daki kodu g\u00f6z \u00f6n\u00fcnde bulundurun.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">With Range(\"A1\").Borders(xlEdgeBottom) .LineStyle = XlLineStyle.xlContinuous .Color = RGB(255, 0, 0) End With<\/code><\/pre><p> Bu makroyu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda h\u00fccrenin alt\u0131na k\u0131rm\u0131z\u0131 renkte bir kenarl\u0131k eklenir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54777\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-en-utilisant-differentes-couleurs-avec-index-de-couleur.png\" sizes=\"auto, \" srcset=\"\" alt=\"renk indeksi ile farkl\u0131 renkler kullanma\" width=\"534\" height=\"225\"><\/figure><\/div><p> Veya colorindex \u00f6zelli\u011fini kullanmak isterseniz kod \u015fu \u015fekilde olacakt\u0131r. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">With Range(\"A1\").Borders(xlEdgeBottom) .LineStyle = XlLineStyle.xlContinuous .ColorIndex = 7 End With<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54835\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Propriete-dindex-de-7-couleurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"renk indeksi \u00f6zelli\u011fi\" width=\"502\" height=\"220\"><\/figure><\/div><p class=\"content-box-green\"> <strong>\u0130lgili:<\/strong> <a href=\"https:\/\/exceladvisor.org\/tr\/ile\/\">Beyanname ile VBA<\/a><\/p><h2 class=\"wp-block-heading\"> H\u00fccrenin i\u00e7ine kenarl\u0131k ekleme<\/h2><p> H\u00fccre i\u00e7ine kenarl\u0131k uygulamak istiyorsan\u0131z bu durumda xlBorderIndex olarak &#8220;xlDiagonalUp&#8221; ve &#8220;xlDiagonalDown&#8221; kullanman\u0131z gerekir. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">With Range(\"A1\").Borders(xlDiagonalUp) .LineStyle = XlLineStyle.xlDashDotDot .Color = RGB(255, 0, 0) End With With Range(\"A1\").Borders(xlDiagonalDown) .LineStyle = XlLineStyle.xlDashDotDot .Color = RGB(255, 0, 0) End With<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54778\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-ajouter-une-bordure-a-linterieur-dune-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"h\u00fccrenin i\u00e7ine kenarl\u0131k ekleme\" width=\"462\" height=\"306\"><\/figure><\/div><p> Yukar\u0131daki kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda h\u00fccrenin i\u00e7ine yukar\u0131 ve a\u015fa\u011f\u0131 bir kenarl\u0131k ekler.<\/p><h2 class=\"wp-block-heading\"> VBA BorderAround y\u00f6ntemi<\/h2><p> VBA&#8217;n\u0131n BorderAround \u00f6zelli\u011finde iste\u011fe ba\u011fl\u0131 5 ba\u011f\u0131ms\u0131z de\u011fi\u015fkeniniz vard\u0131r, ancak s\u0131n\u0131r\u0131n h\u00fccreye do\u011fru \u015fekilde uygulanmas\u0131 i\u00e7in ikisinin belirtilmesi gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54779\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-methode-de-bordure-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba s\u0131n\u0131r \u00f6tesi y\u00f6ntemi\" width=\"589\" height=\"134\"><\/figure><\/div><p> A\u015fa\u011f\u0131daki kod, makroyu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda A1:A3 aral\u0131\u011f\u0131n\u0131n \u00e7evresine kenarl\u0131k uygular. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A3\").BorderAround _ LineStyle:=xlContinuous, _ Weight:=xlThin<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54780\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-specifier-dappliquer-la-bordure-a-une-cellule-de-la-bonne-maniere.png\" sizes=\"auto, \" srcset=\"\" alt=\"kenarl\u0131\u011f\u0131n bir h\u00fccreye do\u011fru \u015fekilde uygulanmas\u0131n\u0131 belirtin\" width=\"487\" height=\"254\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Aral\u0131ktaki her h\u00fccreye kenarl\u0131k ekleme<\/h2><p> A\u015fa\u011f\u0131daki kod aral\u0131ktaki t\u00fcm h\u00fccreler aras\u0131nda d\u00f6ng\u00fc yapar ve kenarl\u0131\u011f\u0131 her h\u00fccreye birer birer uygular. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_borders() Dim iRange As Range Dim iCells As Range Set iRange = Range(\"A1:A10\") For Each iCells In iRange iCells.BorderAround _ LineStyle:=xlContinuous, _ Weight:=xlThin Next iCells End Sub<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-54781\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-ajouter-une-bordure-a-chaque-cellule-de-la-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"Aral\u0131ktaki her h\u00fccreye kenarl\u0131k ekleme\" width=\"414\" height=\"383\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Metin i\u00e7eren t\u00fcm h\u00fccrelere kenarl\u0131k uygula<\/h2><p> A\u015fa\u011f\u0131daki kod, yaln\u0131zca bir de\u011fere sahip oldu\u011funuz h\u00fccrelere kenarl\u0131k uygulamak i\u00e7in FOR LOOP, USED RANGE, IFEMPTY ve IF STATEMENT kullan\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim iRange As Range Dim iCells As Range Set iRange = ThisWorkbook.ActiveSheet.UsedRange For Each iCells In iRange If Not IsEmpty(iCells) Then iCells.BorderAround _ LineStyle:=xlContinuous, _ Weight:=xlThin End If Next iCells<\/code><\/pre><h2 class=\"wp-block-heading\"> Kenarl\u0131klar\u0131 kald\u0131r<\/h2><p> Sadece \u201cxlNone\u201d \u00e7izgi stilini kullan\u0131n.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Borders(xlDiagonalDown).LineStyle = xlNone<\/code><\/pre><p> \u00c7al\u0131\u015fma sayfas\u0131nda bir de\u011fere sahip oldu\u011funuz t\u00fcm h\u00fccrelerin kenarl\u0131\u011f\u0131n\u0131 kald\u0131rmak istiyorsan\u0131z a\u015fa\u011f\u0131daki kodu g\u00f6z \u00f6n\u00fcnde bulundurun.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim iRange As Range Dim iCells As Range Set iRange = ThisWorkbook.ActiveSheet.UsedRange For Each iCells In iRange If Not IsEmpty(iCells) Then iCells.Borders(xlDiagonalDown).LineStyle = xlNone End If Next iCells<\/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\/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 kullanarak bir \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><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-2210","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>\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla h\u00fccreye kenarl\u0131klar nas\u0131l uygulan\u0131r?<\/title>\n<meta name=\"description\" content=\"VBA kodunu kullanarak bir h\u00fccreye kenarl\u0131k uygulaman\u0131n iki farkl\u0131 yolu vard\u0131r. Border ve BorderAround y\u00f6ntemi. Kullanmak i\u00e7in\" \/>\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\/sinirlar\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla h\u00fccreye kenarl\u0131klar nas\u0131l uygulan\u0131r?\" \/>\n<meta property=\"og:description\" content=\"VBA kodunu kullanarak bir h\u00fccreye kenarl\u0131k uygulaman\u0131n iki farkl\u0131 yolu vard\u0131r. Border ve BorderAround y\u00f6ntemi. Kullanmak i\u00e7in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/sinirlar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-specifier-la-plage-ou-la-cellule.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\/sinirlar\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/sinirlar\/\",\"name\":\"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla h\u00fccreye kenarl\u0131klar nas\u0131l uygulan\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/sinirlar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/sinirlar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-specifier-la-plage-ou-la-cellule.png\",\"datePublished\":\"2023-09-01T07:18:23+00:00\",\"dateModified\":\"2023-12-10T06:04:10+00:00\",\"description\":\"VBA kodunu kullanarak bir h\u00fccreye kenarl\u0131k uygulaman\u0131n iki farkl\u0131 yolu vard\u0131r. Border ve BorderAround y\u00f6ntemi. Kullanmak i\u00e7in\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/sinirlar\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/sinirlar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/sinirlar\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-specifier-la-plage-ou-la-cellule.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-specifier-la-plage-ou-la-cellule.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/sinirlar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00fccreye kenarl\u0131klar nas\u0131l uygulan\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":"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla h\u00fccreye kenarl\u0131klar nas\u0131l uygulan\u0131r?","description":"VBA kodunu kullanarak bir h\u00fccreye kenarl\u0131k uygulaman\u0131n iki farkl\u0131 yolu vard\u0131r. Border ve BorderAround y\u00f6ntemi. Kullanmak i\u00e7in","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\/sinirlar\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla h\u00fccreye kenarl\u0131klar nas\u0131l uygulan\u0131r?","og_description":"VBA kodunu kullanarak bir h\u00fccreye kenarl\u0131k uygulaman\u0131n iki farkl\u0131 yolu vard\u0131r. Border ve BorderAround y\u00f6ntemi. Kullanmak i\u00e7in","og_url":"https:\/\/exceladvisor.org\/tr\/sinirlar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-specifier-la-plage-ou-la-cellule.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\/sinirlar\/","url":"https:\/\/exceladvisor.org\/tr\/sinirlar\/","name":"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla h\u00fccreye kenarl\u0131klar nas\u0131l uygulan\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/sinirlar\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/sinirlar\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-specifier-la-plage-ou-la-cellule.png","datePublished":"2023-09-01T07:18:23+00:00","dateModified":"2023-12-10T06:04:10+00:00","description":"VBA kodunu kullanarak bir h\u00fccreye kenarl\u0131k uygulaman\u0131n iki farkl\u0131 yolu vard\u0131r. Border ve BorderAround y\u00f6ntemi. Kullanmak i\u00e7in","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/sinirlar\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/sinirlar\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/sinirlar\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-specifier-la-plage-ou-la-cellule.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-specifier-la-plage-ou-la-cellule.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/sinirlar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"H\u00fccreye kenarl\u0131klar nas\u0131l uygulan\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\/2210","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=2210"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2210\/revisions"}],"predecessor-version":[{"id":2695,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2210\/revisions\/2695"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}