Excel’de makro kullanarak otomatik olarak yeni sayfa ekleyebilirsiniz. A\u015fa\u011f\u0131daki kod A s\u00fctununa yeni eklenen bir verinin ismi ile yeni bir sayfa olu\u015fturmaktad\u0131r. Farkl\u0131 projelerde kullan\u0131labilir. Kodu i\u015flem yapaca\u011f\u0131n\u0131z sayfan\u0131n, sayfa koduna yap\u0131\u015ft\u0131rman\u0131z yeterlidir.<\/p>\n
Private Sub worksheet_change(ByVal target As Range)\r\nIf Intersect([A:A], target) Is Nothing Then Exit Sub\r\nDim WS As Worksheet\r\nSet WS = Sheets.Add\r\n\r\nson = Cells(Rows.Count, \"A\").End(xlUp).Row\r\n\r\nWS.Name = Cells(son, 1)\r\n\r\nEnd Sub<\/pre>\nFaydal\u0131 olmas\u0131 dile\u011fiyle…<\/p>\n
\n","protected":false},"excerpt":{"rendered":"
Excel’de makro kullanarak otomatik olarak yeni sayfa ekleyebilirsiniz. A\u015fa\u011f\u0131daki kod A s\u00fctununa yeni eklenen bir verinin ismi ile yeni bir sayfa olu\u015fturmaktad\u0131r. Farkl\u0131 projelerde kullan\u0131labilir. Kodu i\u015flem yapaca\u011f\u0131n\u0131z sayfan\u0131n, sayfa…<\/p>\n","protected":false},"author":1,"featured_media":805,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_joinchat":[],"footnotes":""},"categories":[206,278],"tags":[350,352,181,180,353,347,348,185,351,354,349],"acf":[],"views":2542,"taxonomy_info":{"category":[{"value":206,"label":"Bilgisayar"},{"value":278,"label":"EXCEL"}],"post_tag":[{"value":350,"label":"add new sheet"},{"value":352,"label":"byval target"},{"value":181,"label":"excel makro"},{"value":180,"label":"excel vba"},{"value":353,"label":"if intersect"},{"value":347,"label":"makro ile otomatik sayfa ekleme"},{"value":348,"label":"makro ile sayfa ekleme"},{"value":185,"label":"makro \u00f6rnekleri"},{"value":351,"label":"rows.count"},{"value":354,"label":"vba \u00f6rnekleri"},{"value":349,"label":"vba sayfa ekleme"}]},"featured_image_src_large":["https:\/\/bymmb.com\/wp-content\/uploads\/2014\/03\/excel.png",512,512,false],"author_info":{"display_name":"bymmb","author_link":"https:\/\/bymmb.com\/author\/bymmb\/"},"comment_info":1,"category_info":[{"term_id":206,"name":"Bilgisayar","slug":"bilgisayar","term_group":0,"term_taxonomy_id":206,"taxonomy":"category","description":"","parent":0,"count":42,"filter":"raw","cat_ID":206,"category_count":42,"category_description":"","cat_name":"Bilgisayar","category_nicename":"bilgisayar","category_parent":0},{"term_id":278,"name":"EXCEL","slug":"excel-2","term_group":0,"term_taxonomy_id":278,"taxonomy":"category","description":"","parent":0,"count":71,"filter":"raw","cat_ID":278,"category_count":71,"category_description":"","cat_name":"EXCEL","category_nicename":"excel-2","category_parent":0}],"tag_info":[{"term_id":350,"name":"add new sheet","slug":"add-new-sheet","term_group":0,"term_taxonomy_id":350,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":352,"name":"byval target","slug":"byval-target","term_group":0,"term_taxonomy_id":352,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":181,"name":"excel makro","slug":"excel-makro","term_group":0,"term_taxonomy_id":181,"taxonomy":"post_tag","description":"","parent":0,"count":10,"filter":"raw"},{"term_id":180,"name":"excel vba","slug":"excel-vba","term_group":0,"term_taxonomy_id":180,"taxonomy":"post_tag","description":"","parent":0,"count":12,"filter":"raw"},{"term_id":353,"name":"if intersect","slug":"if-intersect","term_group":0,"term_taxonomy_id":353,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"},{"term_id":347,"name":"makro ile otomatik sayfa ekleme","slug":"makro-ile-otomatik-sayfa-ekleme","term_group":0,"term_taxonomy_id":347,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":348,"name":"makro ile sayfa ekleme","slug":"makro-ile-sayfa-ekleme","term_group":0,"term_taxonomy_id":348,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":185,"name":"makro \u00f6rnekleri","slug":"makro-ornekleri","term_group":0,"term_taxonomy_id":185,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw"},{"term_id":351,"name":"rows.count","slug":"rows-count","term_group":0,"term_taxonomy_id":351,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":354,"name":"vba \u00f6rnekleri","slug":"vba-ornekleri","term_group":0,"term_taxonomy_id":354,"taxonomy":"post_tag","description":"","parent":0,"count":8,"filter":"raw"},{"term_id":349,"name":"vba sayfa ekleme","slug":"vba-sayfa-ekleme","term_group":0,"term_taxonomy_id":349,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts\/804"}],"collection":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/comments?post=804"}],"version-history":[{"count":0,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts\/804\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/media\/805"}],"wp:attachment":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/media?parent=804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/categories?post=804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/tags?post=804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}