{"id":3830,"date":"2024-12-03T04:30:39","date_gmt":"2024-12-03T04:30:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-lay-ra-danh-sach-ten-cac-sheet-hien-co-trong-excel\/"},"modified":"2024-12-03T04:30:39","modified_gmt":"2024-12-03T04:30:39","slug":"huong-dan-lay-ra-danh-sach-ten-cac-sheet-hien-co-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-lay-ra-danh-sach-ten-cac-sheet-hien-co-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1ea5y ra danh s\u00e1ch t\u00ean c\u00e1c Sheet hi\u1ec7n c\u00f3 trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> <\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n l\u1ea5y ra danh s\u00e1ch t\u00ean c\u1ee7a c\u00e1c Sheet c\u00f3 trong File Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng b\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/excel-vba\"><strong>VBA Excel<\/strong><\/a><\/em><\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c l\u1ea5y ra danh s\u00e1ch \u0111\u01b0\u1ee3c t\u00ean c\u00e1c Sheet hi\u1ec7n c\u00f3 trong File Excel s\u1ebd gi\u00fap cho vi\u1ec7c ki\u1ec3m tra v\u00e0 n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c c\u00e1c Sheet trong File Excel m\u1ed9t c\u00e1ch r\u00f5 r\u00e0ng h\u01a1n. Tr\u01b0\u1eddng h\u1ee3p File c\u1ee7a b\u1ea1n c\u00f3 \u00edt Sheet th\u00ec c\u00f3 th\u1ec3 ch\u01b0a ph\u00e1t sinh nhi\u1ec1u v\u1ea5n \u0111\u1ec1 nh\u01b0ng khi s\u1ed1 l\u01b0\u1ee3ng Sheet ng\u00e0y c\u00e0ng nhi\u1ec1u th\u00ec vi\u1ec7c n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c c\u00e1c sheet s\u1ebd tr\u1edf n\u00ean r\u1ea5t c\u1ea7n thi\u1ebft. Vi\u1ec7c l\u1ea5y ra danh s\u00e1ch t\u00ean c\u00e1c Sheet l\u00e0 b\u01b0\u1edbc \u0111\u1ea7u \u0111\u1ec3 t\u1eeb \u0111\u00f3 c\u00f3 th\u1ec3 gi\u00fap cho vi\u1ec7c t\u1ea1o m\u1ee5c l\u1ee5c cho File Excel c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/tao-muc-luc-tu-dong-trong-excel-bang-vba.html\">S\u1eed d\u1ee5ng VBA \u0111\u1ec3 t\u1ea1o m\u1ee5c l\u1ee5c t\u1ef1 \u0111\u1ed9ng trong Excel<\/a><\/strong><\/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-674e896e9a924\" 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\/huong-dan-lay-ra-danh-sach-ten-cac-sheet-hien-co-trong-excel.html#Lay_danh_sach_ten_cac_Sheet_trong_Excel\" title=\"L\u1ea5y danh s\u00e1ch t\u00ean c\u00e1c Sheet trong Excel\">L\u1ea5y danh s\u00e1ch t\u00ean c\u00e1c Sheet trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lay-ra-danh-sach-ten-cac-sheet-hien-co-trong-excel.html#Tao_ham_lay_ten_cua_Sheet_hien_tai\" title=\"T\u1ea1o h\u00e0m l\u1ea5y t\u00ean c\u1ee7a Sheet hi\u1ec7n t\u1ea1i\">T\u1ea1o h\u00e0m l\u1ea5y t\u00ean c\u1ee7a Sheet hi\u1ec7n t\u1ea1i<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lay-ra-danh-sach-ten-cac-sheet-hien-co-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lay_danh_sach_ten_cac_Sheet_trong_Excel\"><\/span>L\u1ea5y danh s\u00e1ch t\u00ean c\u00e1c Sheet trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3, ta m\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA l\u00ean v\u00e0 c\u00f3 d\u00f2ng Code nh\u01b0 sau, \u1edf \u0111\u00e2y trong File m\u00ecnh c\u00f3 7 Sheet, th\u1ef1c hi\u1ec7n l\u1eb7p qua c\u00e1c Sheet n\u00e0y v\u00e0 l\u1ea7n l\u01b0\u1ee3t l\u1ea5y t\u00ean c\u00e1c Sheet \u0111\u00f3 v\u00e0o Excel<\/p>\n<blockquote>\n<p style=\"padding-left: 30px\">Sub DS_Ws()<br \/>\nDim j As Integer<\/p>\n<p style=\"padding-left: 30px\">For j = 1 To Sheets.Count<br \/>\nSheet7.Cells(j + 1, 1).Value = Sheets(j).Name<br \/>\nNext j<br \/>\nEnd Sub<\/p>\n<p style=\"padding-left: 30px\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30956 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-6-1024x606-1.png\" alt=\"dem-so-sheets-trong-excel-1\" width=\"1024\" height=\"606\" title=\"1-6-1024x606-1\"><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Bi\u1ebfn j \u0111\u01b0\u1ee3c khai b\u00e1o thu\u1ed9c ki\u1ec3u Integer\u00a0 \u1edf tr\u00ean s\u1ebd ch\u1ea1y t\u1eeb Sheet \u0111\u1ea7u ti\u00ean t\u1edbi Sheet cu\u1ed1i c\u00f9ng trong File Excel c\u1ee7a b\u1ea1n v\u00e0 sau \u0111\u00f3 th\u1ef1c hi\u1ec7n ghi v\u00e0o Excel t\u00ean c\u1ee7a Sheet \u0111\u00f3 (Sheets(j).Name)<\/p>\n<p style=\"text-align: justify\">V\u1eeba r\u1ed3i ta \u0111\u00e3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c 1 Sub \u0111\u1ec3 l\u1ea5y ra danh s\u00e1ch t\u00ean c\u1ee7a c\u00e1c Sheet hi\u1ec7n c\u00f3 trong Excel m\u1ed9t c\u00e1ch kh\u00e1 nhanh ch\u00f3ng, N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n m\u00ecnh t\u1ea1o 1 Function trong VBA \u0111\u1ec3 l\u1ea5y ra t\u00ean sheet th\u00ec sao.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_ham_lay_ten_cua_Sheet_hien_tai\"><\/span>T\u1ea1o h\u00e0m l\u1ea5y t\u00ean c\u1ee7a Sheet hi\u1ec7n t\u1ea1i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n t\u1ea1o 1 Function \u0111\u1ec3 l\u1ea5y ra t\u00ean Sheet hi\u1ec7n t\u1ea1i, ta c\u00f3 Code kh\u00e1 \u0111\u01a1n gi\u1ea3n nh\u01b0 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\/2024\/12\/vba101_92019-nho-129.gif\" title=\"vba101_92019-nho-129\"><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\/2024\/12\/ex101_92019-nho-301.gif\" title=\"ex101_92019-nho-301\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>Function MySheet() As String<br \/>\nMySheet = ActiveSheet.Name<br \/>\nEnd Function<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30958 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-6-1.png\" alt=\"dem-so-sheets-trong-excel-2\" width=\"774\" height=\"482\" title=\"2-6-1\"><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">H\u00e0m t\u1ef1 t\u1ea1o n\u00e0y \u0111\u01a1n gi\u1ea3n ch\u1ec9 l\u00e0 l\u1ea5y ra t\u00ean Sheet hi\u1ec7n t\u1ea1i (ActiveSheet.Name) v\u00e0\u00a0s\u1ebd kh\u00f4ng c\u1ea7n truy\u1ec1n \u0111\u1ed1i s\u1ed1 cho h\u00e0m.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Qua b\u00e0i vi\u1ebft n\u00e0y,<strong> H\u1ecdc Excel Online<\/strong> b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c\u00a0c\u00e1ch \u0111\u1ec3 l\u1ea5y ra danh s\u00e1ch t\u00ean c\u1ee7a c\u00e1c Sheet trong File Excel c\u1ee7a m\u00ecnh c\u0169ng nh\u01b0 t\u1ea1o \u0111\u01b0\u1ee3c 1 Function \u0111\u1ec3 l\u1ea5y ra t\u00ean Sheet hi\u1ec7n t\u1ea1i b\u1ea1n \u0111ang l\u00e0m vi\u1ec7c m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/p>\n<p style=\"text-align: justify\">V\u1edbi VBA b\u1ea1n c\u00f2n l\u00e0m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u \u0111i\u1ec1u th\u00fa v\u1ecb v\u00e0 h\u1eefu \u00edch kh\u00e1c gi\u00fap n\u00e2ng cao hi\u1ec7u su\u1ea5t trong c\u00f4ng vi\u1ec7c c\u0169ng nh\u01b0 \u0111em l\u1ea1i hi\u1ec7u qu\u1ea3 cao h\u01a1n khi l\u00e0m vi\u1ec7c v\u1edbi Excel. T<strong><a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\">ham kh\u1ea3o kho\u00e1 h\u1ecdc\u00a0VBA101 \u2013 T\u1ef1 \u0111\u1ed9ng ho\u00e1 Excel v\u1edbi l\u1eadp tr\u00ecnh VBA cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>.<\/strong><\/p>\n<hr>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-msgbox-trong-excel-vba-huong-dan-day-du.html\">S\u1eed d\u1ee5ng Msgbox trong Excel VBA\u2013 h\u01b0\u1edbng d\u1eabn \u0111\u1ea7y \u0111\u1ee7<\/a><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/vba-la-gi-mot-so-vi-du-ung-dung-vba-trong-cong-viec.html\">VBA l\u00e0 g\u00ec? m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 \u1ee9ng d\u1ee5ng VBA trong c\u00f4ng vi\u1ec7c<\/a><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/mot-code-vba-de-tim-dong-cuoi-cung-co-du-lieu-trong-excel.html\">M\u1ed9t s\u1ed1 Code VBA \u0111\u1ec3 t\u00ecm d\u00f2ng cu\u1ed1i c\u00f9ng c\u00f3 d\u1eef li\u1ec7u trong Excel<\/a><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tao-cong-cu-tim-kiem-nhanh-trong-excel.html\">h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o c\u00f4ng c\u1ee5 t\u00ecm ki\u1ebfm nhanh trong Excel b\u1eb1ng VBA<\/a><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-autofilter-hieu-qua-hon-voi-vba.html\">S\u1eed d\u1ee5ng Autofilter hi\u1ec7u qu\u1ea3 h\u01a1n v\u1edbi VBA<\/a><\/p>\n<p style=\"text-align: justify\">\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\/2024\/12\/vba101_92019-nho-129.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3831,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3830","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3830","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=3830"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3830\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3831"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3830"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3830"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}