{"id":7908,"date":"2024-12-21T18:49:15","date_gmt":"2024-12-21T18:49:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tong-hop-kien-thuc-ve-mang-du-lieu-trong-vba\/"},"modified":"2024-12-21T18:49:15","modified_gmt":"2024-12-21T18:49:15","slug":"tong-hop-kien-thuc-ve-mang-du-lieu-trong-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tong-hop-kien-thuc-ve-mang-du-lieu-trong-vba\/","title":{"rendered":"T\u1ed5ng h\u1ee3p ki\u1ebfn th\u1ee9c v\u1ec1 m\u1ea3ng d\u1eef li\u1ec7u trong VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u v\u1ec1 m\u1ea3ng trong l\u1eadp tr\u00ecnh VBA cho c\u00e1c b\u1ea1n. N\u1ed9i dung file PDF ph\u00eda d\u01b0\u1edbi s\u1ebd bao g\u1ed3m nh\u1eefng ki\u1ebfn th\u1ee9c sau:<\/p>\n<ol>\n<li>Khai b\u00e1o m\u1ea3ng<\/li>\n<li>\u0110\u1eb7t k\u00edch th\u01b0\u1edbc cho m\u1ea3ng<\/li>\n<li>Thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc gi\u1eef nguy\u00ean gi\u1eef li\u1ec7u c\u1ee7a m\u1ea3ng<\/li>\n<li>G\u00e1n d\u1eef li\u1ec7u cho ph\u1ea7n t\u1eed trong m\u1ea3ng<\/li>\n<li>L\u1ea5y d\u1eef li\u1ec7u t\u1eeb ph\u1ea7n t\u1eed trong m\u1ea3ng<\/li>\n<li>Ubound v\u00e0 Lbound c\u1ee7a m\u1ea3ng<\/li>\n<li>L\u1eb7p qua c\u00e1c ph\u1ea7n t\u1eed c\u1ee7a m\u1ea3ng 1 chi\u1ec1u \/ 2 chi\u1ec1u<\/li>\n<li>L\u1eb7p b\u1eb1ng for each<\/li>\n<li>Function tr\u1ea3 v\u1ec1 m\u1ea3ng<\/li>\n<li>Xo\u00e1 m\u1ea3ng<\/li>\n<li>T\u1eeb chu\u1ed7i \u0111\u1ebfn m\u1ea3ng<\/li>\n<li>T\u1eeb m\u1ea3ng \u0111\u1ebfn chu\u1ed7i<\/li>\n<li>T\u1eeb Range ra m\u1ea3ng<\/li>\n<li>T\u1eeb m\u1ea3ng ra Range<\/li>\n<li>G\u00e1n gi\u00e1 tr\u1ecb cho 1 m\u1ea3ng<\/li>\n<\/ol>\n<p><strong>Download:<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/Array-in-VBA.pdf\">Array in VBA<\/a><\/p>\n<p>Tham kh\u1ea3o ngay kho\u00e1 h\u1ecdc VBA 101 t\u1eeb H\u1ecdc Excel Online:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/vba101\">https:\/\/blog.hocexcel.online\/vba101<\/a><\/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":"<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u v\u1ec1 m\u1ea3ng trong..<\/p>\n","protected":false},"author":1,"featured_media":7909,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7908","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\/7908","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=7908"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7908\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7909"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}