{"id":12569,"date":"2025-01-15T09:39:40","date_gmt":"2025-01-15T09:39:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/dem-so-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba\/"},"modified":"2025-01-15T09:39:40","modified_gmt":"2025-01-15T09:39:40","slug":"dem-so-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/dem-so-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba\/","title":{"rendered":"\u0110\u1ebfm s\u1ed1 Sheets trong 1 workbooks b\u1eb1ng c\u00f4ng th\u1ee9c ho\u1eb7c VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>Trong ba\u0300i vi\u00ea\u0301t na\u0300y, <strong>H\u1ecdc Excel Online <\/strong>se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n va\u0300 chia se\u0309 \u0111\u00ea\u0301n ca\u0301c ba\u0323n c\u00e1c\u00a0 \u0111\u1ebfm s\u1ed1 Sheets trong 1 workbooks b\u1eb1ng c\u00f4ng th\u1ee9c ho\u1eb7c <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>VBA Excel<\/strong><\/a> c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6787825a27d67\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Cach_1_ket_hop_Named_Range_va_cong_thuc_COUNTA\" title=\"C\u00e1ch 1: k\u1ebft h\u1ee3p Named Range v\u00e0 c\u00f4ng th\u1ee9c COUNTA\">C\u00e1ch 1: k\u1ebft h\u1ee3p Named Range v\u00e0 c\u00f4ng th\u1ee9c COUNTA<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Buoc_1\" title=\"B\u01b0\u1edbc 1\">B\u01b0\u1edbc 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Buoc_2\" title=\"B\u01b0\u1edbc 2\">B\u01b0\u1edbc 2<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Cach_2_ket_hop_Named_Range_va_cong_thuc_COUNTA_INDEX\" title=\"C\u00e1ch 2: k\u1ebft h\u1ee3p Named Range v\u00e0 c\u00f4ng th\u1ee9c COUNTA, INDEX\">C\u00e1ch 2: k\u1ebft h\u1ee3p Named Range v\u00e0 c\u00f4ng th\u1ee9c COUNTA, INDEX<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Buoc_1-2\" title=\"B\u01b0\u1edbc 1\">B\u01b0\u1edbc 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Buoc_2-2\" title=\"B\u01b0\u1edbc 2\">B\u01b0\u1edbc 2<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Cach_3_Su_dung_VBA\" title=\"C\u00e1ch 3: S\u1eed d\u1ee5ng VBA\">C\u00e1ch 3: S\u1eed d\u1ee5ng VBA<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Buoc_1-3\" title=\"B\u01b0\u1edbc 1\">B\u01b0\u1edbc 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Buoc_2-3\" title=\"B\u01b0\u1edbc 2\">B\u01b0\u1edbc 2<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Buoc_3\" title=\"B\u01b0\u1edbc 3\">B\u01b0\u1edbc 3<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/dem-sheets-trong-1-workbooks-bang-cong-thuc-hoac-vba.html#Buoc_4\" title=\"B\u01b0\u1edbc 4\">B\u01b0\u1edbc 4<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_1_ket_hop_Named_Range_va_cong_thuc_COUNTA\"><\/span>C\u00e1ch 1: k\u1ebft h\u1ee3p Named Range v\u00e0 c\u00f4ng th\u1ee9c COUNTA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fa \u00fd: khi \u00e1p d\u1ee5ng c\u00e1ch n\u00e0y b\u1ea1n ph\u1ea3i <strong>l\u01b0u file Excel d\u01b0\u1edbi d\u1ea1ng xlsm<\/strong> c\u00f3 h\u1ed7 tr\u1ee3 Macro b\u1edfi v\u00ec h\u00e0m\u00a0<strong>GET.WORKBOOK<\/strong> s\u1ebd s\u1eed d\u1ee5ng sau \u0111\u00e2y thu\u1ed9c v\u1ec1 Macro 4.0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1\"><\/span>B\u01b0\u1edbc 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1o 1 named Range v\u1edbi c\u00f4ng th\u1ee9c sau \u0111\u00e2y, gi\u1ea3 s\u1eed name n\u00e0y l\u00e0 <strong>num_of_ws<\/strong><\/p>\n<pre>=RIGHT(GET.WORKBOOK(1),LEN(GET.WORKBOOK(1))-FIND(\"]\",GET.WORKBOOK(1)))\r\n\r\n\r\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/01-dem-so-sheet-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-591\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/01-dem-so-sheet-trong-excel.png\" alt=\"01 dem so sheet trong excel\" width=\"557\" height=\"430\" title=\"01-dem-so-sheet-trong-excel\"><\/a><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2\"><\/span>B\u01b0\u1edbc 2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong \u00f4 mu\u1ed1n nh\u1eadn l\u1ea1i k\u1ebft qu\u1ea3 c\u00f3 bao nhi\u00eau sheets, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/p>\n<pre>=COUNTA(num_of_ws)<\/pre>\n<blockquote>\n<p><strong><em><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">H\u1ecdc l\u1eadp tr\u00ecnh VBA trong Excel \u1edf \u0111\u00e2u?<\/a><\/em><\/strong><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Cach_2_ket_hop_Named_Range_va_cong_thuc_COUNTA_INDEX\"><\/span>C\u00e1ch 2: k\u1ebft h\u1ee3p Named Range v\u00e0 c\u00f4ng th\u1ee9c COUNTA, INDEX<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fa \u00fd: khi \u00e1p d\u1ee5ng c\u00e1ch n\u00e0y b\u1ea1n ph\u1ea3i l\u01b0u file Excel d\u01b0\u1edbi d\u1ea1ng xlsm c\u00f3 h\u1ed7 tr\u1ee3 Macro b\u1edfi v\u00ec h\u00e0m GET.WORKBOOK s\u1ebd s\u1eed d\u1ee5ng sau \u0111\u00e2y thu\u1ed9c v\u1ec1 Macro 4.0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1-2\"><\/span>B\u01b0\u1edbc 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1o m\u1ed9t name range v\u1edbi c\u00f4ng th\u1ee9c sau \u0111\u00e2y, gi\u1ea3 s\u1eed name n\u00e0y c\u00f3 t\u00ean l\u00e0 num_of_ws<\/p>\n<pre>=GET.WORKBOOK(1)&amp;T(NOW())\r\n\r\n\r\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/02-dem-so-sheet-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-592\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/02-dem-so-sheet-trong-excel.png\" alt=\"02 dem so sheet trong excel\" width=\"557\" height=\"430\" title=\"02-dem-so-sheet-trong-excel\"><\/a><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2-2\"><\/span>B\u01b0\u1edbc 2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong \u00f4 mu\u1ed1n hi\u1ec7n k\u1ebft qu\u1ea3 c\u1ee7a t\u00e0i li\u1ec7u Excel, s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-80.gif\" title=\"vba101_92019-nho-80\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-412.gif\" title=\"ex101_92019-nho-412\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<pre> =COUNTA(INDEX(num_of_ws,0))<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Cach_3_Su_dung_VBA\"><\/span>C\u00e1ch 3: S\u1eed d\u1ee5ng VBA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1-3\"><\/span>B\u01b0\u1edbc 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA b\u1eb1ng c\u00e1ch b\u1ea5m gi\u1eef ph\u00edm <strong>ALT + F11<\/strong> tr\u00ean b\u00e0n ph\u00edm<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_2-3\"><\/span>B\u01b0\u1edbc 2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1ea1o m\u1ed9t module m\u1edbi b\u1eb1ng c\u00e1ch b\u1ea5m chu\u1ed9t ph\u1ea3i trong c\u1eeda s\u1ed5 Project \u2013 VBAProject v\u00e0 ch\u1ecdn Insert &gt; Module<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/03-dem-so-sheet-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-593\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/03-dem-so-sheet-trong-excel.png\" alt=\"03 dem so sheet trong excel\" width=\"451\" height=\"387\" title=\"03-dem-so-sheet-trong-excel\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_3\"><\/span>B\u01b0\u1edbc 3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong c\u1eeda s\u1ed5 Code, d\u00e1n n\u1ed9i dung code sau v\u00e0o<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/c11782aa27f7ac2c3cd30a3f0e5ac78e\">Gist<\/a>.<\/div>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/04-dem-so-sheet-trong-excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-594\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/04-dem-so-sheet-trong-excel.png\" alt=\"04 dem so sheet trong excel\" width=\"929\" height=\"456\" title=\"04-dem-so-sheet-trong-excel\"><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_4\"><\/span>B\u01b0\u1edbc 4<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea5m ph\u00edm F5 \u0111\u1ec3 ch\u1ea1y macro n\u00e0y v\u00e0 nh\u1eadn k\u1ebft qu\u1ea3.<\/p>\n<p>\u0110\u1ebfn \u0111\u00e2y b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u\u00a0nh\u1eefng\u00a0\u0111i\u1ec1u th\u00fa v\u1ecb c\u1ee7a VBA \u0111\u01b0\u1ee3c r\u1ed3i. VBA\u00a0gi\u00fap \u00edch\u00a0r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean Excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 Word, Power Point, Outlook \u2026 gi\u00fap bi\u1ebfn file Excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p \u2026<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc\u00a0<em><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\"><strong>VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/strong><\/a><\/em> c\u1ee7a h\u1ec7 th\u1ed1ng<strong> H\u1ecdc Excel Online.<\/strong> Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vba101_92019-nho-80.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12570,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12569","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=12569"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12569\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12570"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}