{"id":12500,"date":"2025-01-15T09:07:17","date_gmt":"2025-01-15T09:07:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/su-dung-currentregion-trong-code-vba\/"},"modified":"2025-01-15T09:07:17","modified_gmt":"2025-01-15T09:07:17","slug":"su-dung-currentregion-trong-code-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/su-dung-currentregion-trong-code-vba\/","title":{"rendered":"S\u1eed d\u1ee5ng currentRegion trong code VBA"},"content":{"rendered":"
\n

M\u1ed9t trong nh\u1eefng t\u00e1c v\u1ee5 hay \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u1ea5t trong khi l\u1eadp tr\u00ecnh VBA \u0111\u00f3 l\u00e0 x\u00e1c \u0111\u1ecbnh v\u00f9ng l\u00e0m vi\u1ec7c \u2013 s\u1eed d\u1ee5ng currentRegion trong code VBA.<\/p>\n

Khi s\u1eed d\u1ee5ng currentRegion nh\u01b0 v\u1eady, m\u1ed9t c\u00f4ng vi\u1ec7c ch\u00fang ta r\u1ea5t hay ph\u1ea3i l\u00e0m l\u00e0 x\u00e1c \u0111\u1ecbnh d\u00f2ng cu\u1ed1i ho\u1eb7c c\u1ed9t cu\u1ed1i c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n

2 d\u00f2ng code sau \u0111\u00e2y c\u00f3 th\u1ec3 s\u1ebd r\u1ea5t quen thu\u1ed9c v\u1edbi c\u00e1c b\u1ea1n trong b\u00e0i t\u00ecm d\u00f2ng cu\u1ed1i v\u00e0 c\u1ed9t cu\u1ed1i c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u<\/a><\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n

\u0110\u1ed1i t\u01b0\u1ee3ng Range trong VBA c\u00f3 1 thu\u1ed9c t\u00ednh l\u00e0 currentRegion. Thu\u1ed9c t\u00ednh n\u00e0y x\u00e1c \u0111\u1ecbnh v\u00f9ng l\u00e0m vi\u1ec7c cho ch\u00fang ta.<\/p>\n

<\/a><\/p>\n

Gi\u1ea3 s\u1eed ch\u00fang ta c\u00f3 v\u00f9ng d\u1eef li\u1ec7u t\u1eeb B2:E12 <\/strong>trong Sheet1 <\/strong>(codename),\u00a0<\/strong>nh\u1eefng d\u00f2ng code sau s\u1ebd cho ch\u00fang ta tham chi\u1ebfu \u0111\u1ebfn v\u00f9ng d\u1eef li\u1ec7u \u0111\u00f3 1 c\u00e1ch thu\u1eadn l\u1ee3i:<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

\u0110o\u1ea1n code sau \u0111\u00e2y s\u1ebd in ra c\u00e1c gi\u00e1 tr\u1ecb trong c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u<\/p>\n

\u00a0<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n

N\u1ebfu ch\u00fang ta mu\u1ed1n b\u1ecf d\u00f2ng \u0111\u1ea7u ti\u00ean (th\u01b0\u1eddng l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u):<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n

Nh\u01b0 v\u1eady, vi\u1ec7c s\u1eed d\u1ee5ng currentRegion s\u1ebd gi\u00fap ch\u00fang ta l\u00e0m vi\u1ec7c nhanh ch\u00f3ng h\u01a1n v\u1edbi 1 v\u00f9ng d\u1eef li\u1ec7u x\u00e1c \u0111\u1ecbnh m\u00e0 kh\u00f4ng c\u1ea7n quan t\u00e2m v\u00e0 ki\u1ec3m tra d\u00f2ng cu\u1ed1i c\u00f9ng c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u \u0111ang \u1edf \u0111\u00e2u. Hi v\u1ecdng c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng k\u0129 thu\u1eadt n\u00e0y cho c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.<\/p>\n

\n

\u0110\u0103ng k\u00fd ngay: l\u1edbp h\u1ecdc VBA \u1edf H\u00e0 N\u1ed9i<\/a><\/p>\n<\/blockquote>\n

\u00a0<\/p>\n

\u00a0<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12501,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12500","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\/12500","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=12500"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12500\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12501"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}