{"id":6745,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/registre-numero\/"},"modified":"2021-02-26T08:12:53","modified_gmt":"2021-02-26T08:12:53","slug":"register-id","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/register-id\/","title":{"rendered":"REGISTRE.NUMERO"},"content":{"rendered":"

La fonction REGISTER.ID<\/code> de Microsoft Excel et REGISTRE.NUMERO<\/code> de Google Sheets permet de g\u00e9n\u00e9rer un identifiant unique pour des objets enregistr\u00e9s \u00e0 l’aide des fonctions REGISTER<\/code> (Excel) et REGISTRE<\/code> (Google Sheets). Ces fonctions sont essentielles pour le suivi et la r\u00e9f\u00e9rence des objets cr\u00e9\u00e9s dynamiquement dans vos feuilles de calcul.<\/p>\n

Syntaxe et exemples<\/h2>\n

La syntaxe de la fonction REGISTER.ID<\/code> dans Excel est la suivante :<\/p>\n

REGISTER.ID(module_text, procedure_text)<\/code><\/pre>\n
O\u00f9 :<\/p>\n
    \n
  • module_text<\/strong> : Nom du module dans lequel la proc\u00e9dure est enregistr\u00e9e.<\/li>\n
  • procedure_text<\/strong> : Nom de la proc\u00e9dure enregistr\u00e9e.<\/li>\n<\/ul>\n
    Pour Google Sheets, la syntaxe est :<\/p>\n
    REGISTRE.NUMERO(module_text, procedure_text)<\/code><\/pre>\n
    Par exemple, si une fonction personnalis\u00e9e nomm\u00e9e CalculerTotal<\/code> est enregistr\u00e9e dans un module appel\u00e9 Finances<\/code> dans Excel, vous pouvez obtenir son ID avec la formule :<\/p>\n
    =REGISTER.ID(\"Finances\", \"CalculerTotal\")<\/code><\/pre>\n
    Applications pratiques<\/h2>\n
    1. Suivi des calculs personnalis\u00e9s dans une entreprise<\/h3>\n
    Les fonctionnalit\u00e9s de REGISTER.ID<\/code> permettent de v\u00e9rifier que les bonnes versions des macros soient utilis\u00e9es dans une entreprise. Par exemple, pour une fonction de budget mise \u00e0 jour r\u00e9cemment :<\/p>\n
    Si REGISTER.ID(\"ModuleBudget\", \"CalculerBudget2023\") = 4567 Alors MsgBox \"La version correcte de la fonction est en cours d'utilisation.\" Sinon MsgBox \"Attention : Une ancienne version de la fonction est utilis\u00e9e.\" Fin Si<\/code><\/pre>\n
    2. Automatiser des mod\u00e8les dans Google Sheets<\/h3>\n
    Dans Google Sheets, l\u2019utilisation de REGISTRE.NUMERO<\/code> peut \u00eatre b\u00e9n\u00e9fique pour tracer quelles fonctions sont appel\u00e9es lors de l’utilisation de mod\u00e8les automatis\u00e9s, comme un mod\u00e8le de facturation avec des calculs de taxes et remises. Voici un exemple d’utilisation dans Apps Script :<\/p>\n
    function onEdit(e) { var id = REGISTRE.NUMERO(\"Calculs\", \"CalculerTaxes\"); Logger.log(\"La fonction CalculerTaxes avec l'ID \" + id + \" a \u00e9t\u00e9 ex\u00e9cut\u00e9e.\"); }<\/code><\/pre>\n
    Cette m\u00e9thode garantit que les modifications apport\u00e9es aux scripts sont enregistr\u00e9es et que les versions ad\u00e9quates des fonctions sont utilis\u00e9es.<\/p>\n
    En conclusion, REGISTER.ID<\/code> dans Excel et REGISTRE.NUMERO<\/code> dans Google Sheets sont des outils puissants pour le suivi et la gestion des fonctions personnalis\u00e9es, ce qui est crucial pour maintenir l’int\u00e9grit\u00e9 des processus dans des environnements de feuille de calcul complexes.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le num\u00e9Ro d\u2019identification du RegistRe de la biblioth\u00e8que de liens dynamiques qui a \u00e9t\u00e9 sp\u00e9cifi\u00e9e ou de la RessouRce de code qui a \u00e9t\u00e9 mise en RegistRe pR\u00e9c\u00e9demment<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[318],"tags":[],"class_list":["post-6745","post","type-post","status-publish","format-standard","hentry","category-complements-et-automatisation"],"acf":[],"yoast_head":"\nFonction REGISTER.ID (REGISTRE.NUMERO) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction REGISTER.ID (REGISTRE.NUMERO) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/register-id\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction REGISTER.ID (REGISTRE.NUMERO) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction REGISTER.ID (REGISTRE.NUMERO) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/register-id\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:12:53+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction REGISTER.ID (REGISTRE.NUMERO) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/register-id\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/register-id\/\",\"name\":\"Fonction REGISTER.ID (REGISTRE.NUMERO) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:12:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction REGISTER.ID (REGISTRE.NUMERO) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/register-id\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/register-id\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/register-id\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Compl\u00e9ments et automatisation\",\"item\":\"https:\/\/functiontranslator.com\/fr\/complements-et-automatisation\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"REGISTRE.NUMERO\"}]},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction REGISTER.ID (REGISTRE.NUMERO) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction REGISTER.ID (REGISTRE.NUMERO) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/register-id\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction REGISTER.ID (REGISTRE.NUMERO) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction REGISTER.ID (REGISTRE.NUMERO) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/register-id\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction REGISTER.ID (REGISTRE.NUMERO) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/register-id\/","url":"https:\/\/functiontranslator.com\/fr\/register-id\/","name":"Fonction REGISTER.ID (REGISTRE.NUMERO) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:12:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction REGISTER.ID (REGISTRE.NUMERO) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/register-id\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/register-id\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/register-id\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Compl\u00e9ments et automatisation","item":"https:\/\/functiontranslator.com\/fr\/complements-et-automatisation\/"},{"@type":"ListItem","position":3,"name":"REGISTRE.NUMERO"}]},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6745"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6745\/revisions"}],"predecessor-version":[{"id":29756,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6745\/revisions\/29756"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}