{"id":15615,"date":"2025-07-15T13:34:53","date_gmt":"2025-07-15T13:34:53","guid":{"rendered":"https:\/\/functiontranslator.com\/yazmac-kodu\/"},"modified":"2021-02-25T16:34:47","modified_gmt":"2021-02-25T16:34:47","slug":"register-id","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/register-id\/","title":{"rendered":"YAZMA\u00c7.KODU"},"content":{"rendered":"<h2>Kullan\u0131m\u0131 Excel ve Google Sheets\u2019te YAZMA\u00c7.KODU (REGISTER.ID) Fonksiyonu<\/h2>\n<p>Excel&#8217;de, YAZMA\u00c7.KODU (REGISTER.ID) fonksiyonu, Visual Basic for Applications (VBA) mod\u00fcl\u00fcnde kaydedilmi\u015f olan bir i\u015flev veya yordam\u0131n benzersiz tan\u0131mlay\u0131c\u0131 numaras\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Bu fonksiyon, genellikle makro yaz\u0131m\u0131nda ve karma\u015f\u0131k i\u015flemlerin y\u00f6netiminde tercih edilir. Unutmay\u0131n ki, Google Sheets bu fonksiyonu desteklememektedir; bu nedenle a\u00e7\u0131klamalar yaln\u0131zca Excel i\u00e7in ge\u00e7erlidir.<\/p>\n<h2>Fonksiyon S\u00f6zdizimi ve \u00d6rnekler<\/h2>\n<p>YAZMA\u00c7.KODU fonksiyonunun s\u00f6zdizimi \u015fu \u015fekildedir:<\/p>\n<pre><code>=YAZMA\u00c7.KODU(\"makro_ad\u0131\")<\/code><\/pre>\n<p>\u00d6rne\u011fin, &#8220;Toplama&#8221; ad\u0131nda bir makro tan\u0131mland\u0131 ise, bu makronun benzersiz ID numaras\u0131n\u0131 almak i\u00e7in kullan\u0131l\u0131r:<\/p>\n<pre><code>=YAZMA\u00c7.KODU(\"Toplama\")<\/code><\/pre>\n<h2>Pratik Kullan\u0131m Senaryolar\u0131<\/h2>\n<h2>Kompleks Makro Y\u00f6netimi<\/h2>\n<p>\u00c7ok say\u0131da makro kullan\u0131yorsan\u0131z ve bu makrolar\u0131 belirli bir d\u00fczen i\u00e7inde \u00e7al\u0131\u015ft\u0131rman\u0131z gerekiyorsa, YAZMA\u00c7.KODU de\u011ferlerini kullanarak bu i\u015flemi otomatize edebilirsiniz.<\/p>\n<table>\n<tr>\n<th>Makro Ad\u0131<\/th>\n<th>YAZMA\u00c7.KODU<\/th>\n<\/tr>\n<tr>\n<td>Toplama<\/td>\n<td><code>=YAZMA\u00c7.KODU(\"Toplama\")<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u00c7\u0131karma<\/td>\n<td><code>=YAZMA\u00c7.KODU(\"\u00c7\u0131karma\")<\/code><\/td>\n<\/tr>\n<\/table>\n<p>Bu tabloyu kullanarak, belirli bir s\u0131ra g\u00f6zeterek makrolar\u0131 aktif hale getirebilir ve i\u015flemlerinizi daha verimli hale getirebilirsiniz.<\/p>\n<h2>Hata Ay\u0131klama ve Test<\/h2>\n<p>B\u00fcy\u00fck bir Excel projesinde, \u00e7e\u015fitli makrolar\u0131n etkile\u015fimlerini g\u00f6zlemlemek son derece \u00f6nemlidir. YAZMA\u00c7.KODU fonksiyonu ile her bir makronun ID\u2019sini alabilir, ve bu ID&#8217;leri log dosyalar\u0131nda veya hata kay\u0131tlar\u0131nda kullanabilirsiniz.<\/p>\n<pre><code> 'Makro \u00e7al\u0131\u015ft\u0131r\u0131l\u0131yor... Sub Makro\u00c7al\u0131\u015ft\u0131r(makro_ad\u0131 As String) Dim makro_id As Long makro_id = Application.Run(\"YAZMA\u00c7.KODU\", makro_ad\u0131) 'ID'yi logla Debug.Print \"Makro ID: \" &amp; makro_id Application.Run(makro_ad\u0131) End Sub <\/code><\/pre>\n<p>Bu script, belirli bir makro ad\u0131n\u0131 fonksiyona verir, o makronun ID&#8217;sini al\u0131r ve bu ID&#8217;yi hata ay\u0131klama konsoluna yazd\u0131r\u0131r, ard\u0131ndan belirtilen makroyu \u00e7al\u0131\u015ft\u0131r\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Daha \u00f6nce kaydedilmi\u015f belirli dinamik ba\u011flant\u0131 kitapl\u0131\u011f\u0131 (DLL) veya kod kayna\u011f\u0131n\u0131n yazma\u00e7 kodunu verir<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[585],"tags":[],"class_list":["post-15615","post","type-post","status-publish","format-standard","hentry","category-eklenti-ve-otomasyon"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de REGISTER.ID (YAZMA\u00c7.KODU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar&#039;da REGISTER.ID (YAZMA\u00c7.KODU) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/register-id\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de REGISTER.ID (YAZMA\u00c7.KODU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar&#039;da REGISTER.ID (YAZMA\u00c7.KODU) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/register-id\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:34:47+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel&#039;de REGISTER.ID (YAZMA\u00c7.KODU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/register-id\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/register-id\/\",\"name\":\"Excel'de REGISTER.ID (YAZMA\u00c7.KODU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:53+00:00\",\"dateModified\":\"2021-02-25T16:34:47+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da REGISTER.ID (YAZMA\u00c7.KODU) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/register-id\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/register-id\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/register-id\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Eklenti ve Otomasyon\",\"item\":\"https:\/\/functiontranslator.com\/tr\/eklenti-ve-otomasyon\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"YAZMA\u00c7.KODU\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de REGISTER.ID (YAZMA\u00c7.KODU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da REGISTER.ID (YAZMA\u00c7.KODU) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/register-id\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de REGISTER.ID (YAZMA\u00c7.KODU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da REGISTER.ID (YAZMA\u00c7.KODU) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/register-id\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:53+00:00","article_modified_time":"2021-02-25T16:34:47+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de REGISTER.ID (YAZMA\u00c7.KODU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/register-id\/","url":"https:\/\/functiontranslator.com\/tr\/register-id\/","name":"Excel'de REGISTER.ID (YAZMA\u00c7.KODU) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:53+00:00","dateModified":"2021-02-25T16:34:47+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da REGISTER.ID (YAZMA\u00c7.KODU) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/register-id\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/register-id\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/register-id\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Eklenti ve Otomasyon","item":"https:\/\/functiontranslator.com\/tr\/eklenti-ve-otomasyon\/"},{"@type":"ListItem","position":3,"name":"YAZMA\u00c7.KODU"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15615"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15615\/revisions"}],"predecessor-version":[{"id":26883,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15615\/revisions\/26883"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}