{"id":1548,"date":"2023-11-17T09:38:55","date_gmt":"2023-11-17T09:38:55","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/"},"modified":"2023-12-10T06:07:55","modified_gmt":"2023-12-10T06:07:55","slug":"kullanilan-aralik","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/","title":{"rendered":"Vba&#39;da userange \u00f6zelli\u011fi nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3693845365\"><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, UseRange \u00f6zelli\u011fi, veri i\u00e7eren bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n aral\u0131\u011f\u0131n\u0131 temsil eder. Kullan\u0131lan aral\u0131k, \u00e7al\u0131\u015fma sayfas\u0131nda bir de\u011fere sahip oldu\u011funuz ilk h\u00fccreden, bir de\u011fere sahip oldu\u011funuz son h\u00fccreye kadar ba\u015flar. T\u0131pk\u0131 A1 ile C11 aras\u0131ndaki aral\u0131\u011f\u0131 kulland\u0131\u011f\u0131n\u0131z a\u015fa\u011f\u0131daki \u00f6rnek gibi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53428\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\" sizes=\"auto, \" srcset=\"\" alt=\"kullan\u0131lan aral\u0131k \u00f6zelli\u011fi\" width=\"521\" height=\"295\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Not: UseRange \u00f6zelli\u011fi salt okunur bir \u00f6zelliktir<\/strong> .<\/p><h2 class=\"wp-block-heading\"> UseRange ile kod yaz\u0131n<\/h2><p> A\u015fa\u011f\u0131daki kodu kullan\u0131n.<\/p><ol type=\"1\"><li> \u00d6ncelikle elektronik tabloyu belirtmeniz gerekir.<\/li><li> Daha sonra bir nokta (.) girin ve \u201cUsedRange\u201d girin.<\/li><li> Bundan sonra kullanmak istedi\u011finiz \u00f6zelli\u011fi veya y\u00f6ntemi kullan\u0131n.<\/li><li> Sonunda kodu \u00e7al\u0131\u015ft\u0131r\u0131n.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() ActiveSheet.UsedRange.Clear End Sub<\/code><\/pre><p> Yukar\u0131daki kod, aktif sayfan\u0131n kullan\u0131lan aral\u0131\u011f\u0131ndaki her \u015feyi temizler.<\/p><h2 class=\"wp-block-heading\"> Kullan\u0131lan aral\u0131\u011f\u0131 kopyala<\/h2><p> Kullan\u0131lm\u0131\u015fRange&#8217;\u0131n tamam\u0131n\u0131 kopyalamak i\u00e7in a\u015fa\u011f\u0131daki kodu kullan\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53429\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-copier-toute-la-plage-utilisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"kullan\u0131lan aral\u0131\u011f\u0131n tamam\u0131n\u0131 kopyala\" width=\"551\" height=\"410\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() ActiveSheet.UsedRange.Copy End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Kullan\u0131lan aral\u0131ktaki sat\u0131rlar\u0131 ve s\u00fctunlar\u0131 say\u0131n<\/h2><p> Kullan\u0131lan aral\u0131\u011f\u0131n sat\u0131r ve s\u00fctunlar\u0131n\u0131 saymak i\u00e7in kullanabilece\u011finiz bir count \u00f6zelli\u011fi vard\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox ActiveSheet.UsedRange.Rows.Count MsgBox ActiveSheet.UsedRange.Columns.Count<\/code><\/pre><p> Yukar\u0131daki iki kod sat\u0131r\u0131, kullan\u0131lan aral\u0131ktaki sat\u0131r ve s\u00fctun say\u0131s\u0131n\u0131 i\u00e7eren bir mesaj kutusu g\u00f6r\u00fcnt\u00fcler.<\/p><h2 class=\"wp-block-heading\"> Kullan\u0131lan aral\u0131ktaki son h\u00fccreyi etkinle\u015ftir<\/h2><p> Ayr\u0131ca kullan\u0131lan aral\u0131ktaki son h\u00fccreyi de etkinle\u015ftirebilirsiniz (bu, \u00e7al\u0131\u015fma sayfas\u0131nda kullan\u0131lan son h\u00fccre olacakt\u0131r). A\u015fa\u011f\u0131daki kodu g\u00f6z \u00f6n\u00fcnde bulundurun. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53430\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-dernieres-cellules-actives-de-la-plage-utilisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"kullan\u0131lan aral\u0131\u011f\u0131n son aktif h\u00fccresi\" width=\"641\" height=\"403\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() Dim iCol As Long Dim iRow As Long iRow = ActiveSheet.UsedRange.Rows.Count iCol = ActiveSheet.UsedRange.Columns.Count ActiveSheet.UsedRange.Select Selection.Cells(iRow, iCol).Select End Sub<\/code><\/pre><p> Bu kod, UseRange \u00f6zelli\u011fini kullanarak sat\u0131r ve s\u00fctun say\u0131s\u0131n\u0131 al\u0131r ve ard\u0131ndan bu say\u0131lar\u0131, kullan\u0131lan aral\u0131ktaki son h\u00fccreyi se\u00e7mek i\u00e7in kullan\u0131r.<\/p><h2 class=\"wp-block-heading\"> Ba\u015fka bir \u00e7al\u0131\u015fma sayfas\u0131ndaki Kullan\u0131lm\u0131\u015fRange&#8217;a bak\u0131n<\/h2><p> Etkin sayfa d\u0131\u015f\u0131nda bir \u00e7al\u0131\u015fma sayfas\u0131nda kullan\u0131lan aral\u0131\u011fa ba\u015fvurmaya \u00e7al\u0131\u015f\u0131rsan\u0131z VBA, buna benzer bir hata g\u00f6sterecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53431\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-plage-utilisee-dans-une-autre-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"ba\u015fka bir \u00e7al\u0131\u015fma sayfas\u0131nda kullan\u0131lan aral\u0131k\" width=\"465\" height=\"331\"><\/figure><\/div><p> Bu nedenle, bahsetti\u011finiz \u00e7al\u0131\u015fma sayfas\u0131n\u0131n etkinle\u015ftirilmesi gerekir (yaln\u0131zca o zaman UseRange \u00f6zelli\u011fini kullanabilirsiniz).<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() Worksheets(\"Sheet4\").Activate Worksheets(\"Sheet4\").UsedRange.Select End Sub<\/code><\/pre><p> Bu, kapal\u0131 bir \u00e7al\u0131\u015fma kitab\u0131nda kullan\u0131lan aral\u0131\u011fa ba\u015fvuramayaca\u011f\u0131n\u0131z anlam\u0131na gelir. Ancak \u00f6nce bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7abilir ve ard\u0131ndan \u00e7al\u0131\u015fma sayfas\u0131n\u0131n UseRange \u00f6zelli\u011fini kullanmas\u0131n\u0131 sa\u011flayabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Kullan\u0131lan aral\u0131\u011f\u0131n adresini al\u0131n<\/h2><p> Kullan\u0131lan aral\u0131\u011f\u0131n adresini almak i\u00e7in a\u015fa\u011f\u0131daki kod sat\u0131r\u0131n\u0131 kullan\u0131n.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() MsgBox ActiveSheet.UsedRange.Address End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Kullan\u0131lan aral\u0131ktaki bo\u015f h\u00fccreleri say<\/h2><p> A\u015fa\u011f\u0131daki kod, <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\">FOR (Her Biri \u0130\u00e7in) d\u00f6ng\u00fclerini<\/a> kullan\u0131r ve kullan\u0131lan aral\u0131ktaki t\u00fcm h\u00fccreler aras\u0131nda d\u00f6ng\u00fc yapar ve bo\u015f h\u00fccreleri sayar.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_used_range() Dim iCell As Range Dim iRange As Range Dim c As Long Dim i As Long Set iRange = ActiveSheet.UsedRange For Each iCell In ActiveSheet.UsedRange c = c + 1 If IsEmpty(iCell) = True Then i = i + 1 End If Next iCell MsgBox \"There are total \" &amp; c &amp; _ \" cell(s) in the range, and out of those \" &amp; _ i &amp; \" cell(s) are empty.\" End Sub<\/code><\/pre><p> Bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, toplam h\u00fccre say\u0131s\u0131n\u0131 ve bo\u015f h\u00fccre say\u0131s\u0131n\u0131 i\u00e7eren bir <a href=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\">mesaj kutusu<\/a> g\u00f6r\u00fcnt\u00fclenir.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/vba\/\">VBA nedir<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/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 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-1548","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>Excel&#039;de VBA&#039;da UseRange \u00f6zelli\u011fi nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"UseRange \u00f6zelli\u011fi, veri i\u00e7eren bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n aral\u0131\u011f\u0131n\u0131 temsil eder. De\u011ferinizin oldu\u011fu ilk h\u00fccreyle ba\u015flar ve\" \/>\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\/kullanilan-aralik\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de VBA&#039;da UseRange \u00f6zelli\u011fi nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"UseRange \u00f6zelli\u011fi, veri i\u00e7eren bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n aral\u0131\u011f\u0131n\u0131 temsil eder. De\u011ferinizin oldu\u011fu ilk h\u00fccreyle ba\u015flar ve\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.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\/kullanilan-aralik\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/\",\"name\":\"Excel&#39;de VBA&#39;da UseRange \u00f6zelli\u011fi nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\",\"datePublished\":\"2023-11-17T09:38:55+00:00\",\"dateModified\":\"2023-12-10T06:07:55+00:00\",\"description\":\"UseRange \u00f6zelli\u011fi, veri i\u00e7eren bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n aral\u0131\u011f\u0131n\u0131 temsil eder. De\u011ferinizin oldu\u011fu ilk h\u00fccreyle ba\u015flar ve\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba&#39;da userange \u00f6zelli\u011fi 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":"Excel&#39;de VBA&#39;da UseRange \u00f6zelli\u011fi nas\u0131l kullan\u0131l\u0131r?","description":"UseRange \u00f6zelli\u011fi, veri i\u00e7eren bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n aral\u0131\u011f\u0131n\u0131 temsil eder. De\u011ferinizin oldu\u011fu ilk h\u00fccreyle ba\u015flar ve","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\/kullanilan-aralik\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de VBA&#39;da UseRange \u00f6zelli\u011fi nas\u0131l kullan\u0131l\u0131r?","og_description":"UseRange \u00f6zelli\u011fi, veri i\u00e7eren bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n aral\u0131\u011f\u0131n\u0131 temsil eder. De\u011ferinizin oldu\u011fu ilk h\u00fccreyle ba\u015flar ve","og_url":"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:55+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.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\/kullanilan-aralik\/","url":"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/","name":"Excel&#39;de VBA&#39;da UseRange \u00f6zelli\u011fi nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png","datePublished":"2023-11-17T09:38:55+00:00","dateModified":"2023-12-10T06:07:55+00:00","description":"UseRange \u00f6zelli\u011fi, veri i\u00e7eren bir \u00e7al\u0131\u015fma sayfas\u0131n\u0131n aral\u0131\u011f\u0131n\u0131 temsil eder. De\u011ferinizin oldu\u011fu ilk h\u00fccreyle ba\u015flar ve","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-propriete-usedrange.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/kullanilan-aralik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba&#39;da userange \u00f6zelli\u011fi 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\/1548","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=1548"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1548\/revisions"}],"predecessor-version":[{"id":2959,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1548\/revisions\/2959"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}