{"id":1547,"date":"2023-11-17T10:14:05","date_gmt":"2023-11-17T10:14:05","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/"},"modified":"2023-12-06T06:16:24","modified_gmt":"2023-12-06T06:16:24","slug":"sel-aktif-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/","title":{"rendered":"Bagaimana cara menggunakan activecell di vba di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3535640839\"><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>Di VBA, sel aktif adalah properti yang mewakili sel yang sedang aktif. Saat Anda memilih sel atau menavigasi ke sel dan kotak hijau ini menutupi sel tersebut, Anda dapat menggunakan properti ACTIVECELL untuk merujuk ke sel tersebut dalam kode VBA. Ada properti dan metode yang menyertainya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53412\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-propriete-activecell.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan properti sel aktif\" width=\"416\" height=\"268\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Gunakan properti sel aktif<\/h2><ol type=\"1\"><li> Ketikkan kata kunci \u201cActiveCell\u201d.<\/li><li> Ketikkan titik (.) untuk mendapatkan properti dan metode dari daftar.<\/li><li> Pilih properti atau metode yang ingin Anda gunakan.<\/li><li> Jalankan kode untuk melakukan aktivitas pada sel aktif. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-53413\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-executez-le-code-de-propriete-activecell.png\" sizes=\"auto, \" srcset=\"\" alt=\"jalankan kode properti activecell\" width=\"440\" height=\"307\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Poin penting<\/h2><ul><li> Saat Anda menggunakan properti sel aktif, VBA merujuk ke sel aktif pada <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/\">lembar aktif<\/a> <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-buku-kerja\/\">buku kerja yang aktif<\/a> , terlepas dari berapa banyak buku kerja yang terbuka saat ini.<\/li><li> ActiveCell pada akhirnya adalah sel dengan semua properti dan metode sel normal.<\/li><\/ul><h2 class=\"wp-block-heading\"> Aktifkan sel dari rentang yang dipilih<\/h2><p> Untuk mengaktifkan sel menggunakan kode VBA, Anda dapat menggunakan metode &#8220;Aktifkan&#8221; dan metode &#8220;Pilih&#8221; dengan dua cara.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_activecell() 'select and entire range Range(\"A1:A10\").Select 'select the cell A3 from the selected range Range(\"A3\").Activate 'clears everything from the active cell ActiveCell.Clear End Sub<\/code><\/pre><p> Kode di atas, pertama-tama, pilih rentang A1:A10, lalu aktifkan sel A3 dari situ dan pada akhirnya, hapus semuanya dari sel aktif yaitu A3.<\/p><h2 class=\"wp-block-heading\"> Mengembalikan nilai sel aktif<\/h2><p> Kode berikut mengembalikan nilai sel aktif menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/kotak-pesan-vba\/\">kotak pesan<\/a> .<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox ActiveCell.Value<\/code><\/pre><p> Atau jika Anda ingin mendapatkan nilai sel yang aktif dan menempelkannya ke sel terpisah.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\") = ActiveCell.Value<\/code><\/pre><h2 class=\"wp-block-heading\"> Setel sel aktif ke variabel<\/h2><p> Anda juga dapat mengatur sel aktif ke <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">variabel<\/a> , seperti pada contoh berikut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_activecell() 'declares the variable as range Dim myCell As Range 'set active cell to the variable Set myCell = ActiveCell 'enter value in the active cell myCell.Value = Done End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> Dapatkan nomor baris dan kolom ActiveCell<\/h2><p> Dengan sel aktif, terdapat properti baris dan kolom yang bisa Anda gunakan untuk mendapatkan nomor baris dan kolom sel aktif.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox ActiveCell.Row MsgBox ActiveCell.Column<\/code><\/pre><h2 class=\"wp-block-heading\"> Dapatkan alamat sel aktif<\/h2><p> Anda dapat menggunakan properti alamat untuk mendapatkan alamat sel aktif.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">MsgBox ActiveCell.Address<\/code><\/pre><p> Saat Anda menjalankan kode di atas, ini menunjukkan kepada Anda kotak pesan dengan alamat sel sel aktif dari lembar aktif buku kerja aktif (seperti yang saya sebutkan sebelumnya).<\/p><h2 class=\"wp-block-heading\"> Pindah dari sel aktif menggunakan offset<\/h2><p> Dengan properti offset, Anda dapat berpindah ke sel yang jaraknya beberapa baris dan kolom dari sel aktif.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ActiveCell.Offset(2, 2).Select<\/code><\/pre><h2 class=\"wp-block-heading\"> Pilih rentang di sel aktif<\/h2><p> Dan Anda juga dapat memilih rentang dari sel yang aktif.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(ActiveCell.Offset(1, 1), ActiveCell.Offset(5, 5)).Select<\/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\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/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\/id\/jumlah-baris\/\">Hitung baris menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/\">Font Excel VBA (warna, ukuran, jenis dan tebal)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sembunyikan-tampilkan-baris-kolom\/\">Excel VBA Sembunyikan dan tampilkan kolom atau baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rentang-1\/\">Rentang VBA Excel \u2013 Bekerja dengan Rentang dan Sel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1547","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 Bagaimana cara menggunakan ActiveCell di VBA di Excel?<\/title>\n<meta name=\"description\" content=\"Untuk merujuk ke sel aktif di Excel menggunakan VBA, Anda perlu menggunakan properti ActiveCell yang memberi Anda akses\" \/>\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\/id\/sel-aktif-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menggunakan ActiveCell di VBA di Excel?\" \/>\n<meta property=\"og:description\" content=\"Untuk merujuk ke sel aktif di Excel menggunakan VBA, Anda perlu menggunakan properti ActiveCell yang memberi Anda akses\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-propriete-activecell.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/\",\"name\":\"\u25b7 Bagaimana cara menggunakan ActiveCell di VBA di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-propriete-activecell.png\",\"datePublished\":\"2023-11-17T10:14:05+00:00\",\"dateModified\":\"2023-12-06T06:16:24+00:00\",\"description\":\"Untuk merujuk ke sel aktif di Excel menggunakan VBA, Anda perlu menggunakan properti ActiveCell yang memberi Anda akses\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-propriete-activecell.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-propriete-activecell.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan activecell di vba di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara menggunakan ActiveCell di VBA di Excel?","description":"Untuk merujuk ke sel aktif di Excel menggunakan VBA, Anda perlu menggunakan properti ActiveCell yang memberi Anda akses","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\/id\/sel-aktif-1\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menggunakan ActiveCell di VBA di Excel?","og_description":"Untuk merujuk ke sel aktif di Excel menggunakan VBA, Anda perlu menggunakan properti ActiveCell yang memberi Anda akses","og_url":"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-propriete-activecell.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/","url":"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/","name":"\u25b7 Bagaimana cara menggunakan ActiveCell di VBA di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-propriete-activecell.png","datePublished":"2023-11-17T10:14:05+00:00","dateModified":"2023-12-06T06:16:24+00:00","description":"Untuk merujuk ke sel aktif di Excel menggunakan VBA, Anda perlu menggunakan properti ActiveCell yang memberi Anda akses","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/sel-aktif-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-propriete-activecell.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-la-propriete-activecell.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/sel-aktif-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan activecell di vba di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1547"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1547\/revisions"}],"predecessor-version":[{"id":2529,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1547\/revisions\/2529"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}