{"id":1892,"date":"2023-10-29T17:51:23","date_gmt":"2023-10-29T17:51:23","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/"},"modified":"2023-12-10T06:06:10","modified_gmt":"2023-12-10T06:06:10","slug":"yeni-bir-sayfa-ekle-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/","title":{"rendered":"Vba kodunu kullanarak yeni bir sayfa nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-350961112\"><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 \u00f6\u011frenmeye ba\u015flad\u0131\u011f\u0131n\u0131zda yapabilece\u011finiz en harika \u015feylerden biri, \u00e7al\u0131\u015fma kitab\u0131na yeni bir \u00e7al\u0131\u015fma sayfas\u0131 eklemek i\u00e7in VBA kodu yazmakt\u0131r.<\/p><p> Yeni bir \u00e7al\u0131\u015fma sayfas\u0131 eklemek i\u00e7in zaten bir k\u0131sayol tu\u015fu var veya normal se\u00e7ene\u011fi de kullanabilirsiniz, ancak VBA kodunu kullanman\u0131n avantaj\u0131, tek t\u0131klamayla birden fazla \u00e7al\u0131\u015fma sayfas\u0131 ekleyebilmeniz ve nereye eklemek istedi\u011finizi de tan\u0131mlayabilmenizdir. BT.<\/p><p> Bunun i\u00e7in Sheets.Add y\u00f6ntemini kullanman\u0131z gerekiyor ve bu yaz\u0131m\u0131zda \u00e7al\u0131\u015fma kitab\u0131na bir veya daha fazla \u00e7al\u0131\u015fma sayfas\u0131 eklemek i\u00e7in nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frenece\u011fiz.<\/p><h2 class=\"wp-block-heading\"> E-Tablolar.Add y\u00f6ntemi<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sheets.Add ([Before], [After], [Count], [Type])<\/code><\/pre><ul><li> \u00d6nce: Bir sayfan\u0131n \u00f6n\u00fcne yeni bir sayfa eklemek i\u00e7in.<\/li><li> Sonra: Yeni sayfay\u0131 bir sayfan\u0131n \u00f6n\u00fcne eklemek i\u00e7in.<\/li><li> Say\u0131m: eklenecek sayfa say\u0131s\u0131.<\/li><li> T\u00fcr: Eklemek istedi\u011finiz sayfan\u0131n t\u00fcr\u00fc ( <a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.xlsheettype\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"LINK (opens in a new tab)\">LINK<\/a> )<\/li><\/ul><h2 class=\"wp-block-heading\"> \u00c7al\u0131\u015fma kitab\u0131na yeni bir sayfa eklemek i\u00e7in VBA kodunu yaz\u0131n<\/h2><p> Visual Basic d\u00fczenleyicisini a\u00e7\u0131n ve \u015fu ad\u0131mlar\u0131 izleyin.<\/p><ul><li> \u00d6ncelikle Sheets.Add metoduna girmeniz gerekiyor.<\/li><li> Daha sonra, yeni sayfay\u0131 nereye ekleyece\u011finizi (\u00d6nce veya Sonra) tan\u0131mlaman\u0131z gerekir.<\/li><li> Bir sonraki \u015fey \u00e7al\u0131\u015fma sayfas\u0131 say\u0131s\u0131n\u0131 girmektir.<\/li><li> Sonu\u00e7ta, sayfa t\u00fcr\u00fc. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-47897\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-feuilles-ajouter-une-methode-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-sheets-ekleme-vba-y\u00f6ntemi\" width=\"597\" height=\"161\"><\/figure><\/div><h2 class=\"wp-block-heading\"> VBA kodunu kullanarak \u00e7al\u0131\u015fma kitab\u0131na yeni sayfalar eklemenin farkl\u0131 yollar\u0131<\/h2><p> A\u015fa\u011f\u0131da \u00e7al\u0131\u015fma kitab\u0131na yeni bir sayfa eklemenin farkl\u0131 yollar\u0131 verilmi\u015ftir:<\/p><h3 class=\"wp-block-heading\"> 1. Tek bir sayfa ekleyin<\/h3><p> Tek sayfa eklemek i\u00e7in herhangi bir arg\u00fcman belirtmedi\u011finiz a\u015fa\u011f\u0131daki kodu kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub SheetAddExample1() ActiveWorkbook.Sheets.Add End Sub<\/code><\/pre><p> Bu kod, Excel&#8217;e etkin \u00e7al\u0131\u015fma kitab\u0131na bir sayfa eklemesini s\u00f6yler, ancak arg\u00fcman\u0131n\u0131z olmad\u0131\u011f\u0131ndan varsay\u0131lanlar\u0131 kullan\u0131r ve etkin sayfan\u0131n \u00f6n\u00fcne bir \u00e7al\u0131\u015fma sayfas\u0131 (xlWorksheet) ekler.<\/p><p> \u0130\u015fte bunu yazman\u0131n ba\u015fka bir yolu, a\u015fa\u011f\u0131daki koda bak\u0131n.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub SheetAddExample2() Sheets.Add End Sub<\/code><\/pre><p> Zaten aktif \u00e7al\u0131\u015fma kitab\u0131nda oldu\u011funuz i\u00e7in a\u015fa\u011f\u0131daki kodu da kullanabilirsiniz. O da ayn\u0131 \u015feyi yap\u0131yor.<\/p><h3 class=\"wp-block-heading\"> 2. Birden fazla sayfa ekleyin<\/h3><p> Ayn\u0131 anda birden fazla sayfa eklemek i\u00e7in COUNT ba\u011f\u0131ms\u0131z de\u011fi\u015fkenini eklemek istedi\u011finiz sayfa say\u0131s\u0131na g\u00f6re ayarlaman\u0131z yeterlidir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub AddSheets3() Sheets.Add Count:=5 End Sub<\/code><\/pre><p> Art\u0131k ayarlad\u0131\u011f\u0131n\u0131z sayfa say\u0131s\u0131 5&#8217;tir, yani bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, be\u015f yeni sayfay\u0131 an\u0131nda \u00e7al\u0131\u015fma kitab\u0131na ekler.<\/p><h3 class=\"wp-block-heading\"> 3. Ad\u0131 olan bir sayfa ekleyin<\/h3><p> Sayfay\u0131 ekledikten sonra yeniden adland\u0131rmak isterseniz a\u015fa\u011f\u0131daki kodu kullanabilirsiniz:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub AddNewSheetswithNameExample1() Sheets.Add.Name = \"myNewSHeet\" End Sub<\/code><\/pre><p> Yukar\u0131daki kodda, bir sayfan\u0131n ad\u0131n\u0131 belirtmenize yard\u0131mc\u0131 olan ad ( <a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/api\/excel.names\">LINK<\/a> ) nesnesini kulland\u0131k.<\/p><h3 class=\"wp-block-heading\"> 4. Bir h\u00fccreden bir ad i\u00e7eren bir sayfa ekleyin<\/h3><p> Ayr\u0131ca, sayfa ad\u0131 olarak kullan\u0131lacak de\u011feri bir h\u00fccreden de alabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub AddNewSheetswithNameExample2() Sheets.Add.Name = Range(\"A1\") End Sub<\/code><\/pre><p> Yukar\u0131daki kodda, yeni sayfan\u0131n ad\u0131n\u0131 almak i\u00e7in A1 h\u00fccresi kullan\u0131ld\u0131.<\/p><h3 class=\"wp-block-heading\"> 5. Belirli bir sayfan\u0131n sonras\u0131na\/\u00f6ncesine bir sayfa ekleyin<\/h3><p> Bu arg\u00fcmanlar zaten Sheets.Add&#8217;de mevcut oldu\u011fundan, \u00f6ncesine veya sonras\u0131na yeni bir sayfa eklenecek sayfay\u0131 belirtebilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub AddSheetsExample5() Sheets.Add Before:=Worksheets(\"mySheet\") Sheets.Add After:=Worksheets(\"mySheet\") End Sub<\/code><\/pre><p> \u015eimdi yukar\u0131daki kodda, Sheet.Add y\u00f6ntemindeki bir arg\u00fcmandan \u00f6nce ve sonra kulland\u0131\u011f\u0131n\u0131z iki sat\u0131r kod var. Yani bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda, &#8220;mySheet&#8221;ten \u00f6nce ve sonra olmak \u00fczere iki sayfa eklenir.<\/p><h3 class=\"wp-block-heading\"> 6. Ba\u015fa yeni bir sayfa ekleyin<\/h3><p> Kullanmadan \u00f6nce ba\u011f\u0131ms\u0131z de\u011fi\u015fkenini kullanarak, \u00e7al\u0131\u015fma kitab\u0131n\u0131zdaki sayfalar\u0131n ba\u015f\u0131na da bir sayfa ekleyebilirsiniz.<\/p><p> Yani temel olarak yapaca\u011f\u0131m\u0131z \u015fey, sayfa ad\u0131 yerine sayfa numaras\u0131n\u0131 belirtmek olacakt\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub AddSheetsExample6() Sheets.Add Before:=Sheets(1) End Sub<\/code><\/pre><p> Yukar\u0131daki kodda, VBA&#8217;ya sayfay\u0131 t\u00fcm \u00e7al\u0131\u015fma sayfalar\u0131nda ilk konumdaki sayfan\u0131n \u00f6n\u00fcne eklemesini s\u00f6yleyen sayfa numaras\u0131n\u0131 (1) kulland\u0131n\u0131z. Bu \u015fekilde her zaman yeni sayfay\u0131 en ba\u015fa ekleyecektir.<\/p><h3 class=\"wp-block-heading\"> 7. Sona yeni bir sayfa ekleyin (son sayfadan sonra)<\/h3><p> Sonuna yeni bir sayfa eklemek i\u00e7in kodu farkl\u0131 bir \u015fekilde yazman\u0131z gerekir. Bunun i\u00e7in \u00e7al\u0131\u015fma kitab\u0131nda ka\u00e7 sayfa oldu\u011funu bilmeniz gerekir, b\u00f6ylece sonuna yeni bir sayfa ekleyebilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub AddSheetsExample8() Sheets.Add After:=Sheets(Sheets.Count) End Sub<\/code><\/pre><p> Yukar\u0131daki kodda Sheet.Count, \u00e7al\u0131\u015fma kitab\u0131ndaki sayfa say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr ve after arg\u00fcman\u0131n\u0131 ayarlad\u0131\u011f\u0131n\u0131z i\u00e7in yeni sayfay\u0131 \u00e7al\u0131\u015fma kitab\u0131ndaki son sayfan\u0131n sonras\u0131na ekler.<\/p><h3 class=\"wp-block-heading\"> 8. Birden \u00c7ok Sayfa Ekleyin ve Aral\u0131k Adlar\u0131n\u0131 Kullan\u0131n<\/h3><p> A\u015fa\u011f\u0131daki kod A1:A7 aral\u0131\u011f\u0131ndaki sat\u0131rlar\u0131 sayar. Bundan sonra aral\u0131k say\u0131s\u0131na g\u00f6re sayfa eklemek i\u00e7in d\u00f6ng\u00fc yapar ve eklerken sayfay\u0131 adland\u0131rmak i\u00e7in aral\u0131k de\u011ferlerini kullan\u0131r.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub AddSheetsExample9() Dim sheets_count As Integer Dim sheet_name As String Dim i As Integer sheet_count = Range(\"A1:A7\").Rows.Count For i = 1 To sheet_count sheet_name = Sheets(\"mySheet\").Range(\"A1:A7\").Cells(i, 1).Value Worksheets.Add().Name = sheet_name Next i End Sub<\/code><\/pre><p> Ancak yukar\u0131daki kodla eklemek istedi\u011finiz sayfan\u0131n ad\u0131n\u0131n zaten mevcut olmas\u0131 veya ad aral\u0131\u011f\u0131nda bo\u015f bir h\u00fccrenizin olmas\u0131 m\u00fcmk\u00fcnd\u00fcr.<\/p><p> Bu durumda ayn\u0131 isimli sayfan\u0131n mevcut olup olmad\u0131\u011f\u0131n\u0131, sayfa ad\u0131n\u0131 almak istedi\u011finiz h\u00fccrenin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 kontrol edebilecek bir kod yazman\u0131z gerekmektedir.<\/p><p> Her iki ko\u015ful da yerine getirilirse yeni bir sayfa eklenmelidir. Bunu iki ad\u0131mda anlatay\u0131m:<\/p><p> <strong>\u00d6ncelikle<\/strong> ayn\u0131 isimde bir sayfan\u0131n mevcut olup olmad\u0131\u011f\u0131n\u0131 kontrol etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/tr\/kullanici-tanimli-fonksiyon-2\/\">Excel kullan\u0131c\u0131 tan\u0131ml\u0131 bir fonksiyon<\/a> yazman\u0131z gerekir.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Function SheetCheck(sheet_name As String) As Boolean Dim ws As Worksheet SheetCheck = False For Each ws In ThisWorkbook.Worksheets If ws.Name = sheet_name Then SheetCheck = True End If Next End Function<\/code><\/pre><p> \u0130kinci olarak bu fonksiyonu kullanarak bir kod yazman\u0131z gerekiyor ve bu kodun ayn\u0131 zamanda isim h\u00fccresinin bo\u015f olup olmad\u0131\u011f\u0131n\u0131 da kontrol etmesi gerekiyor.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub AddMultipleSheet2() Dim sheets_count As Integer Dim sheet_name As String Dim i As Integer sheet_count = Range(\"A1:A7\").Rows.Count For i = 1 To sheet_count sheet_name = Sheets(\"mySheet\").Range(\"A1:A10\").Cells(i, 1).Value If SheetCheck(sheet_name) = False And sheet_name &lt;&gt; \"\" Then Worksheets.Add().Name = sheet_name End If Next i End Sub<\/code><\/pre><p> \u015eimdi yukar\u0131daki kodda <a href=\"https:\/\/exceladvisor.org\/tr\/eger-2\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"VBA IF Statement (opens in a new tab)\">VBA IF ifadesini<\/a> kulland\u0131n\u0131z ve bu ifadede sayfa ad\u0131n\u0131 kontrol eden sayfa kontrol i\u015flevine sahipsiniz ve ard\u0131ndan ad h\u00fccresinin bo\u015f bir de\u011fere sahip olup olmad\u0131\u011f\u0131n\u0131 kontrol edecek bir ko\u015fulunuz var.<\/p><p> <strong><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/add-sheet-using-vba.zip\" target=\"_blank\" rel=\"noreferrer noopener nofollow\" aria-label=\"Sample File (opens in a new tab)\">\u00d6rnek dosya<\/a><\/strong><\/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\/temiz-sayfa\/\">Excel&#8217;de VBA kullanarak bir sayfan\u0131n tamam\u0131n\u0131 TEM\u0130ZLEY\u0130N<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-kopyala\/\">VBA&#8217;y\u0131 kullanarak Excel&#8217;de bir sayfay\u0131 kopyalay\u0131n ve ta\u015f\u0131y\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/\">Excel&#8217;de VBA kullanan COUNT Sayfa<\/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\/calisma-sayfasi-1\/\">VBA \u00c7al\u0131\u015fma Sayfas\u0131 Nesnesi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sayfayi-etkinlestir\/\">VBA kullanarak bir sayfay\u0131 etkinle\u015ftirme<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kontrol-sayfasi-mevcut\/\">VBA Bir sayfan\u0131n olup olmad\u0131\u011f\u0131n\u0131 kontrol edin<\/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-1892","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 yeni bir sayfa nas\u0131l olu\u015fturulur?<\/title>\n<meta name=\"description\" content=\"SHEETS.ADD ad\u0131nda \u00f6zel bir y\u00f6ntem var. Bu y\u00f6ntem temel olarak bizim kulland\u0131\u011f\u0131m\u0131z bir fonksiyona benzer.\" \/>\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-sayfa-ekle-1\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA kodunu kullanarak yeni bir sayfa nas\u0131l olu\u015fturulur?\" \/>\n<meta property=\"og:description\" content=\"SHEETS.ADD ad\u0131nda \u00f6zel bir y\u00f6ntem var. Bu y\u00f6ntem temel olarak bizim kulland\u0131\u011f\u0131m\u0131z bir fonksiyona benzer.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:06:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-feuilles-ajouter-une-methode-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=\"6 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-sayfa-ekle-1\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/\",\"name\":\"VBA kodunu kullanarak yeni bir sayfa nas\u0131l olu\u015fturulur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-feuilles-ajouter-une-methode-vba.png\",\"datePublished\":\"2023-10-29T17:51:23+00:00\",\"dateModified\":\"2023-12-10T06:06:10+00:00\",\"description\":\"SHEETS.ADD ad\u0131nda \u00f6zel bir y\u00f6ntem var. Bu y\u00f6ntem temel olarak bizim kulland\u0131\u011f\u0131m\u0131z bir fonksiyona benzer.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-feuilles-ajouter-une-methode-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-feuilles-ajouter-une-methode-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba kodunu kullanarak yeni bir sayfa nas\u0131l olu\u015fturulur?\"}]},{\"@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 yeni bir sayfa nas\u0131l olu\u015fturulur?","description":"SHEETS.ADD ad\u0131nda \u00f6zel bir y\u00f6ntem var. Bu y\u00f6ntem temel olarak bizim kulland\u0131\u011f\u0131m\u0131z bir fonksiyona benzer.","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-sayfa-ekle-1\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA kodunu kullanarak yeni bir sayfa nas\u0131l olu\u015fturulur?","og_description":"SHEETS.ADD ad\u0131nda \u00f6zel bir y\u00f6ntem var. Bu y\u00f6ntem temel olarak bizim kulland\u0131\u011f\u0131m\u0131z bir fonksiyona benzer.","og_url":"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:06:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-feuilles-ajouter-une-methode-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"6 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/","url":"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/","name":"VBA kodunu kullanarak yeni bir sayfa nas\u0131l olu\u015fturulur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-feuilles-ajouter-une-methode-vba.png","datePublished":"2023-10-29T17:51:23+00:00","dateModified":"2023-12-10T06:06:10+00:00","description":"SHEETS.ADD ad\u0131nda \u00f6zel bir y\u00f6ntem var. Bu y\u00f6ntem temel olarak bizim kulland\u0131\u011f\u0131m\u0131z bir fonksiyona benzer.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-feuilles-ajouter-une-methode-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-feuilles-ajouter-une-methode-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/yeni-bir-sayfa-ekle-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba kodunu kullanarak yeni bir sayfa nas\u0131l olu\u015fturulur?"}]},{"@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\/1892","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=1892"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1892\/revisions"}],"predecessor-version":[{"id":2854,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1892\/revisions\/2854"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}