{"id":2155,"date":"2023-09-28T17:33:35","date_gmt":"2023-09-28T17:33:35","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/ile\/"},"modified":"2023-12-10T06:04:11","modified_gmt":"2023-12-10T06:04:11","slug":"ile","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/ile\/","title":{"rendered":"I\u0307\u00e7 i\u00e7e vba i\u0307le deyimi nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3776539275\"><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 class=\"wp-block-heading\"><strong>Anahtar noktalar\u0131<\/strong><\/p><ul><li> <em>Kodu simge durumuna k\u00fc\u00e7\u00fcltmek i\u00e7in VBA With deyimini kullan\u0131n.<\/em><\/li><li> <em>With deyimini kullan\u0131rken ayn\u0131 anda yaln\u0131zca bir nesne kullanabilirsiniz.<\/em><\/li><\/ul><h2 class=\"wp-block-heading\"> Beyanname ile VBA nedir<\/h2><p> VBA With, bir nesneyi bir kez belirtmek ve ard\u0131ndan onun i\u00e7in birden fazla ifadeyi y\u00fcr\u00fctmek i\u00e7in kullan\u0131lan bir ifadedir. Basit bir ifadeyle \u201cWITH\u201d ifadesini kullanarak bir nesneyi belirtebilir ve sonras\u0131nda t\u00fcm \u00f6zelliklere ve y\u00f6ntemlere tek seferde eri\u015febilirsiniz. &#8220;\u0130le&#8221; ile ba\u015flar ve &#8220;Bitir&#8221; ile biter.<\/p><h2 class=\"wp-block-heading\"> \u0130fadeyle VBA&#8217;n\u0131n s\u00f6zdizimi<\/h2><p> VBA&#8217;da With deyimini kullanmak i\u00e7in kullanman\u0131z gereken s\u00f6zdizimi \u015f\u00f6yledir: <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">With [OBJECT] [Statement] End With<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51528\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-syntaxe-de-vba-avec-instruction.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-s\u00f6zdizimi-ifadesi ile\" width=\"340\" height=\"257\"><\/figure><\/div><ol><li> <strong>With<\/strong> : Bu, VBA&#8217;ya s\u00f6z konusu nesneyi belirtti\u011finizi bildiren ifadenin ba\u015flang\u0131\u00e7 anahtar s\u00f6zc\u00fc\u011f\u00fcd\u00fcr.<\/li><li> <strong>Object<\/strong> : Burada kullanmak istedi\u011finiz nesneyi belirtmeniz gerekmektedir.<\/li><li> <strong>\u0130fade<\/strong> : Belirtilen nesneyle y\u00fcr\u00fctmek istedi\u011finiz bir veya daha fazla ifade.<\/li><li> <strong>End With<\/strong> : Bu, ifadenin biti\u015f anahtar s\u00f6zc\u00fc\u011f\u00fcd\u00fcr.<\/li><\/ol><h2 class=\"wp-block-heading\"> A\u00e7\u0131klamal\u0131 VBA&#8217;y\u0131 anlama \u00f6rne\u011fi<\/h2><p> Derinlemesine ifadeyle anla\u015f\u0131lmas\u0131 i\u00e7in bir \u00f6rnek alal\u0131m. A1 h\u00fccresinin yaz\u0131 tipi rengini, boyutunu ve ad\u0131n\u0131 de\u011fi\u015ftirmek istedi\u011finizi varsayal\u0131m. Bu \u00fc\u00e7 \u015feyi yapmak i\u00e7in \u00fc\u00e7 farkl\u0131 <a href=\"https:\/\/exceladvisor.org\/tr\/karakter-yazi-tipi\/\">VBA yaz\u0131 tipi<\/a> \u00f6zelli\u011fine eri\u015fmeniz gerekir; kod \u015f\u00f6yle olacakt\u0131r:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Font.Color = RGB(0, 0, 255) Range(\"A1\").Font.Size = 16 Range(\"A1\").Font.Name = \"Consolas\"<\/code><\/pre><p> Ancak burada yukar\u0131daki kod yerine With ifadesini kullanaca\u011f\u0131z. VBA With deyimini kullanmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz:<\/p><ol><li> \u0130lk \u00f6nce klavyeyi \u201cWith\u201d yaz\u0131n.<\/li><li> Bundan sonra, yaz\u0131 tipi nesnesini belirtmek i\u00e7in yaz\u0131 tipi nesnesini kullanarak A1 h\u00fccresini belirtmek i\u00e7in VBA aral\u0131\u011f\u0131n\u0131 kullan\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"2 kullan\u0131ml\u0131 vba aral\u0131\u011f\u0131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-la-gamme-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-the-vba-range\" width=\"336\" height=\"202\"><\/li><li> Daha sonra \u00fc\u00e7 \u00f6zelli\u011fin kodunu ve uygulamak istedi\u011finiz de\u011ferleri girmeniz gerekiyor. <br><img loading=\"lazy\" decoding=\"async\" title=\"\u00dc\u00e7 \u00f6zellik i\u00e7in 3 kod\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-code-pour-les-trois-proprietes.png\" sizes=\"auto, \" srcset=\"\" alt=\"code-for-all-three-properties\" width=\"337\" height=\"209\"><\/li><li> Sonunda, ifadeyi sonland\u0131rmak i\u00e7in \u201cEnd With\u201d anahtar kelimesini kullan\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-ifadenin sonundan sonuna kadar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-fin-avec-pour-terminer-linstruction.png\" sizes=\"auto, \" srcset=\"\" alt=\"end-with-to-end-the-statement\" width=\"331\" height=\"258\"><\/li><\/ol><p> \u0130\u015fte az \u00f6nce yazd\u0131\u011f\u0131n\u0131z kod.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub MyMacro() With Range(\"A1\").Font .Color = RGB(0, 0, 255) .Size = 16 .Name = \"Consolas\" End With End Sub<\/code><\/pre><p> \u015eimdi her iki koda da bakal\u0131m ve &#8220;With&#8221; ifadesini kullanarak ne gibi bir fark\u0131m\u0131z oldu\u011funu anlamaya \u00e7al\u0131\u015fal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51532\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-regardez-les-deux-codes.png\" sizes=\"auto, \" srcset=\"\" alt=\"iki koda bak\" width=\"596\" height=\"404\"><\/figure><\/div><p> \u0130lk kodda yaz\u0131 tipi nesnesini \u00fc\u00e7 kez kulland\u0131n\u0131z ve ard\u0131ndan eri\u015fmek istedi\u011finiz ve de\u011fi\u015fiklik yapmak istedi\u011finiz \u00f6zelli\u011fi kulland\u0131n\u0131z.<\/p><p> Ancak ikinci kodda With deyimini kulland\u0131n\u0131z ve hemen yaz\u0131 tipi nesnesini belirttiniz. Ve ard\u0131ndan \u00fc\u00e7 \u00f6zelli\u011fe eri\u015fmek i\u00e7in \u201cWith\u201d ifadesinde \u00fc\u00e7 sat\u0131r kod.<\/p><p> &#8220;With&#8221; ifadesini kullan\u0131p bir nesne belirtti\u011finizde, VBA&#8217;ya yazd\u0131\u011f\u0131n\u0131z t\u00fcm ifadelerin s\u00f6z konusu nesneyle birlikte y\u00fcr\u00fct\u00fclmesi gerekti\u011fini s\u00f6yler. Bu size yaln\u0131zca yap\u0131land\u0131r\u0131lm\u0131\u015f kod sa\u011flamakla kalmaz, ayn\u0131 zamanda bir makronun y\u00fcr\u00fct\u00fclmesini h\u0131zland\u0131r\u0131r ve ona daha fazla verimlilik sa\u011flar.<\/p><h2 class=\"wp-block-heading\"> \u0130fadeyle i\u00e7 i\u00e7e<\/h2><p> With ifadesini kullanmak i\u00e7in yaln\u0131zca bir nesne belirtebilece\u011finizi ba\u015flang\u0131\u00e7ta s\u00f6ylemi\u015ftim. Ancak onunla birden fazla, hatta birden fazla \u00f6\u011feyi kullanman\u0131n bir yolu var. Bu, <a href=\"https:\/\/exceladvisor.org\/tr\/donguler\/\">VBA LOOPS<\/a> kullan\u0131yor ve birden fazla nesne aras\u0131nda d\u00f6ng\u00fc yapmak ve &#8220;With&#8221; se\u00e7ene\u011fini kullanmak i\u00e7in FOR EACH LOOP&#8217;u kullanaca\u011f\u0131z.<\/p><p> Sana bir \u00f6rnek vereyim; t\u00fcm \u00e7al\u0131\u015fma sayfalar\u0131n\u0131 g\u00f6zden ge\u00e7irmeniz ve a\u015fa\u011f\u0131dakilerin t\u00fcm\u00fcn\u00fc her \u00e7al\u0131\u015fma sayfas\u0131ndaki t\u00fcm h\u00fccrelere uygulaman\u0131z gerekir.<\/p><ul><li> <strong>Yaz\u0131 tipi boyutu: 16<\/strong><\/li><li> <strong>Yaz\u0131 tipi: Verdena<\/strong><\/li><\/ul><p> \u00c7al\u0131\u015fma kitab\u0131nda da a\u015fa\u011f\u0131daki \u00f6rnekte oldu\u011fu gibi be\u015f \u00e7al\u0131\u015fma sayfan\u0131z var: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51533\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-imbriques-avec-declaration.png\" sizes=\"auto, \" srcset=\"\" alt=\"ifadeyle i\u00e7 i\u00e7e\" width=\"515\" height=\"198\"><\/figure><\/div><p> <strong>\u0130\u00e7 i\u00e7e ge\u00e7mi\u015f bir &#8220;With&#8221; ifadesi yazmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullan\u0131n.<\/strong><\/p><ol><li> \u00d6ncelikle bir \u00e7al\u0131\u015fma sayfas\u0131 nesnesini kullanmak i\u00e7in bir de\u011fi\u015fken bildirmeniz gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"\u0130\u00e7 i\u00e7e yazmak i\u00e7in 7 ad\u0131m\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-etapes-pour-ecrire-imbrique.png\" sizes=\"auto, \" srcset=\"\" alt=\"steps-to-write-nested\" width=\"327\" height=\"212\"><\/li><li> Bundan sonra dedi\u011fim gibi <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-icin\/\">For Every Loop<\/a> kullanman\u0131z gerekiyor. Bu nedenle <a href=\"https:\/\/exceladvisor.org\/tr\/dongu-yapraklari\/\">, t\u00fcm \u00e7al\u0131\u015fma sayfalar\u0131nda dola\u015fabilecek<\/a> d\u00f6ng\u00fcye sahip bir kod yazman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"8-d\u00f6ng\u00fcyle-kod yazma\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-ecrire-du-code-avec-la-boucle.png\" sizes=\"auto, \" srcset=\"\" alt=\"write-code-with-the-loop\" width=\"400\" height=\"238\"><\/li><li> \u015eimdi yukar\u0131da tart\u0131\u015ft\u0131\u011f\u0131m\u0131z <a href=\"https:\/\/exceladvisor.org\/tr\/karakter-yazi-tipi\/\">yaz\u0131 tipi<\/a> ayar\u0131n\u0131 uygulayabilecek with ifadesini girin. \u00c7al\u0131\u015fma sayfas\u0131ndaki <a href=\"https:\/\/exceladvisor.org\/tr\/hepsini-sec\/\">t\u00fcm h\u00fccrelere at\u0131fta bulunmak<\/a> i\u00e7in konuyu belirtirken \u201cH\u00fccreler\u201d komutunu kullanabilirsiniz. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-nesneyi-belirtirken-h\u00fccreleri kullan\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-utiliser-des-cellules-tout-en-specifiant-lobjet.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-cells-while-specifing-the-object\" width=\"383\" height=\"304\"><\/li><\/ol><p> \u0130\u015fte az \u00f6nce yazd\u0131\u011f\u0131n\u0131z kodun tamam\u0131.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub MyMacro() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets With Cells .Font.Size = 16 .Font.Name = \"Verdena\" End With Next ws 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\/gorusme-sorulari\/\">VBA M\u00fclakat Sorular\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yorum\/\">VBA koduna yorum ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/satir-sonu\/\">VBA koduna sat\u0131r sonu ekleme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yeni-hat\/\">VBA&#8217;da bir dizeye yeni bir sat\u0131r (sat\u0131r ba\u015f\u0131) ekleyin<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">Excel&#8217;de Makro \u00c7al\u0131\u015ft\u0131rma (VBA Kodunu \u00c7al\u0131\u015ft\u0131rma)<\/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-2155","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 Yuvalanm\u0131\u015f VBA YOUR deyimi nas\u0131l kullan\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Bir nesneyi bir kez belirtmek ve daha sonra onun i\u00e7in birden fazla ifadeyi y\u00fcr\u00fctmek i\u00e7in &quot;With&quot; ifadesini kullanabilirsiniz. Olabilir\" \/>\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\/ile\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Yuvalanm\u0131\u015f VBA YOUR deyimi nas\u0131l kullan\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bir nesneyi bir kez belirtmek ve daha sonra onun i\u00e7in birden fazla ifadeyi y\u00fcr\u00fctmek i\u00e7in &quot;With&quot; ifadesini kullanabilirsiniz. Olabilir\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/ile\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:04:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-syntaxe-de-vba-avec-instruction.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=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ile\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/ile\/\",\"name\":\"\u25b7 Yuvalanm\u0131\u015f VBA YOUR deyimi nas\u0131l kullan\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ile\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ile\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-syntaxe-de-vba-avec-instruction.png\",\"datePublished\":\"2023-09-28T17:33:35+00:00\",\"dateModified\":\"2023-12-10T06:04:11+00:00\",\"description\":\"Bir nesneyi bir kez belirtmek ve daha sonra onun i\u00e7in birden fazla ifadeyi y\u00fcr\u00fctmek i\u00e7in &quot;With&quot; ifadesini kullanabilirsiniz. Olabilir\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/ile\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/ile\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ile\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-syntaxe-de-vba-avec-instruction.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-syntaxe-de-vba-avec-instruction.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/ile\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"I\u0307\u00e7 i\u00e7e vba i\u0307le deyimi 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":"\u25b7 Yuvalanm\u0131\u015f VBA YOUR deyimi nas\u0131l kullan\u0131l\u0131r?","description":"Bir nesneyi bir kez belirtmek ve daha sonra onun i\u00e7in birden fazla ifadeyi y\u00fcr\u00fctmek i\u00e7in &quot;With&quot; ifadesini kullanabilirsiniz. Olabilir","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\/ile\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Yuvalanm\u0131\u015f VBA YOUR deyimi nas\u0131l kullan\u0131l\u0131r?","og_description":"Bir nesneyi bir kez belirtmek ve daha sonra onun i\u00e7in birden fazla ifadeyi y\u00fcr\u00fctmek i\u00e7in &quot;With&quot; ifadesini kullanabilirsiniz. Olabilir","og_url":"https:\/\/exceladvisor.org\/tr\/ile\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:04:11+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-syntaxe-de-vba-avec-instruction.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/ile\/","url":"https:\/\/exceladvisor.org\/tr\/ile\/","name":"\u25b7 Yuvalanm\u0131\u015f VBA YOUR deyimi nas\u0131l kullan\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/ile\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/ile\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-syntaxe-de-vba-avec-instruction.png","datePublished":"2023-09-28T17:33:35+00:00","dateModified":"2023-12-10T06:04:11+00:00","description":"Bir nesneyi bir kez belirtmek ve daha sonra onun i\u00e7in birden fazla ifadeyi y\u00fcr\u00fctmek i\u00e7in &quot;With&quot; ifadesini kullanabilirsiniz. Olabilir","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/ile\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/ile\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/ile\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-syntaxe-de-vba-avec-instruction.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-syntaxe-de-vba-avec-instruction.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/ile\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"I\u0307\u00e7 i\u00e7e vba i\u0307le deyimi 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\/2155","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=2155"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2155\/revisions"}],"predecessor-version":[{"id":2698,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2155\/revisions\/2698"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}