{"id":7619,"date":"2024-12-21T18:08:52","date_gmt":"2024-12-21T18:08:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/su-dung-vba-macro-trong-excel-de-xoa-hang-hoac-loai-bo-moi-hang-khac\/"},"modified":"2024-12-21T18:08:52","modified_gmt":"2024-12-21T18:08:52","slug":"su-dung-vba-macro-trong-excel-de-xoa-hang-hoac-loai-bo-moi-hang-khac","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/su-dung-vba-macro-trong-excel-de-xoa-hang-hoac-loai-bo-moi-hang-khac\/","title":{"rendered":"S\u1eed d\u1ee5ng VBA Macro trong Excel \u0111\u1ec3 x\u00f3a h\u00e0ng ho\u1eb7c lo\u1ea1i b\u1ecf m\u1ecdi h\u00e0ng kh\u00e1c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel Online s\u1ebd li\u1ec7t k\u00ea m\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ec3 xo\u00e1 c\u00e1c h\u00e0ng trong Excel 2010-2016 d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb \u00f4. B\u00e0i n\u00e0y c\u0169ng gi\u1edbi thi\u1ec7u c\u00e1c ph\u00edm t\u1eaft v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\" target=\"_blank\" rel=\"noopener noreferrer\">VBA trong Excel<\/a>. X\u00f3a h\u00e0ng m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng ho\u1eb7c s\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Find k\u1ebft h\u1ee3p v\u1edbi c\u00e1c ph\u00edm t\u1eaft h\u1eefu \u00edch.<\/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-676704337ac6c\" 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\/su-dung-vba-macro-trong-excel-de-xoa-hang-hoac-loai-bo-moi-hang-khac.html#Phim_tat_nhanh_nhat_de_xoa_cac_hang_trong_bang_cua_ban\" title=\"Ph\u00edm t\u1eaft nhanh nh\u1ea5t \u0111\u1ec3 x\u00f3a c\u00e1c h\u00e0ng trong b\u1ea3ng c\u1ee7a b\u1ea1n:\">Ph\u00edm t\u1eaft nhanh nh\u1ea5t \u0111\u1ec3 x\u00f3a c\u00e1c h\u00e0ng trong b\u1ea3ng c\u1ee7a b\u1ea1n:<\/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\/su-dung-vba-macro-trong-excel-de-xoa-hang-hoac-loai-bo-moi-hang-khac.html#Xoa_hang_khoi_toan_bo_bang\" title=\"X\u00f3a h\u00e0ng kh\u1ecfi to\u00e0n b\u1ed9 b\u1ea3ng\">X\u00f3a h\u00e0ng kh\u1ecfi to\u00e0n b\u1ed9 b\u1ea3ng<\/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\/su-dung-vba-macro-trong-excel-de-xoa-hang-hoac-loai-bo-moi-hang-khac.html#Xoa_hang_neu_co_du_lieu_o_ben_phai_bang\" title=\"X\u00f3a h\u00e0ng n\u1ebfu c\u00f3 d\u1eef li\u1ec7u \u1edf b\u00ean ph\u1ea3i b\u1ea3ng\">X\u00f3a h\u00e0ng n\u1ebfu c\u00f3 d\u1eef li\u1ec7u \u1edf b\u00ean ph\u1ea3i b\u1ea3ng<\/a><\/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\/su-dung-vba-macro-trong-excel-de-xoa-hang-hoac-loai-bo-moi-hang-khac.html#Xoa_cac_hang_co_chua_du_lieu_dinh_trong_mot_cot\" title=\"X\u00f3a c\u00e1c h\u00e0ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u \u0111\u1ecbnh trong m\u1ed9t c\u1ed9t\">X\u00f3a c\u00e1c h\u00e0ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u \u0111\u1ecbnh trong m\u1ed9t c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/su-dung-vba-macro-trong-excel-de-xoa-hang-hoac-loai-bo-moi-hang-khac.html#Excel_VBA_Macro_de_xoa_hang_hoac_loai_bo_moi_hang_khac\" title=\"Excel VBA Macro \u0111\u1ec3 x\u00f3a h\u00e0ng ho\u1eb7c lo\u1ea1i b\u1ecf m\u1ecdi h\u00e0ng kh\u00e1c\">Excel VBA Macro \u0111\u1ec3 x\u00f3a h\u00e0ng ho\u1eb7c lo\u1ea1i b\u1ecf m\u1ecdi h\u00e0ng kh\u00e1c<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Phim_tat_nhanh_nhat_de_xoa_cac_hang_trong_bang_cua_ban\"><\/span><strong>Ph\u00edm t\u1eaft nhanh nh\u1ea5t \u0111\u1ec3 x\u00f3a c\u00e1c h\u00e0ng trong b\u1ea3ng c\u1ee7a b\u1ea1n:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p nhanh nh\u1ea5t \u0111\u1ec3 x\u00f3a nhi\u1ec1u h\u00e0ng theo gi\u00e1 tr\u1ecb \u00f4, tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n ch\u1ecdn c\u00e1c h\u00e0ng n\u00e0y.<\/p>\n<p>\u0110\u1ec3 ch\u1ecdn c\u00e1c h\u00e0ng, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00e1c \u00f4 tr\u00ean h\u00e0ng c\u1ea7n \u0111\u00e1nh d\u1ea5u v\u00e0 nh\u1ea5n <strong>Shift + Space<\/strong> ho\u1eb7c ch\u1ecdn c\u00e1c \u00f4 kh\u00f4ng li\u1ec1n k\u1ec1 b\u1eb1ng c\u00e1ch gi\u1eef ph\u00edm <strong>Ctrl.<\/strong><\/p>\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 h\u00e0ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c n\u00fat s\u1ed1 h\u00e0ng. B\u1ea1n s\u1ebd th\u1ea5y h\u00e0ng \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u00ean c\u1ea1nh n\u00fat s\u1ed1 h\u00e0ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5450 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-48.png\" width=\"524\" height=\"240\" title=\"excel-find-replace-highlight-48\"><\/p>\n<p>Sau khi b\u1ea1n ch\u1ecdn c\u00e1c h\u00e0ng, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng x\u00f3a ch\u00fang b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ph\u00edm t\u1eaft \u201cDelete Row\u201d c\u1ee7a Excel. D\u01b0\u1edbi \u0111\u00e2y b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y c\u00e1ch x\u00f3a h\u00e0ng \u0111\u00e3 ch\u1ecdn cho d\u00f9 b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u ho\u1eb7c b\u1ea3ng c\u00f3 ch\u1ee9a c\u1ea3 d\u1eef li\u1ec7u ph\u00eda b\u00ean ph\u1ea3i.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Xoa_hang_khoi_toan_bo_bang\"><\/span><strong>X\u00f3a h\u00e0ng kh\u1ecfi to\u00e0n b\u1ed9 b\u1ea3ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch Excel \u0111\u01a1n gi\u1ea3n m\u00e0 kh\u00f4ng c\u00f3 th\u00f4ng tin b\u1ed5 sung \u1edf b\u00ean ph\u1ea3i, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft x\u00f3a h\u00e0ng \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c h\u00e0ng trong 2 b\u01b0\u1edbc d\u1ec5 d\u00e0ng:<\/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-308.gif\" title=\"vba101_92019-nho-308\"><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-683.gif\" title=\"ex101_92019-nho-683\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>1. Ch\u1ecdn h\u00e0ng b\u1ea1n mu\u1ed1n x\u00f3a.<\/p>\n<p>2. Nh\u1ea5n ph\u00edm t\u1eaft <strong>Ctrl + \u2013 (tr\u1eeb tr\u00ean b\u00e0n ph\u00edm ch\u00ednh)<\/strong>.<\/p>\n<p>B\u1ea1n s\u1ebd th\u1ea5y c\u00e1c h\u00e0ng kh\u00f4ng s\u1eed d\u1ee5ng bi\u1ebfn m\u1ea5t trong nh\u00e1y m\u1eaft.<\/p>\n<p><strong>M\u1eb9o<\/strong>. B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111\u00e1nh d\u1ea5u m\u00e0u v\u00f9ng ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf. Sau \u0111\u00f3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft <strong>Ctrl + \u2013 (tr\u1eeb tr\u00ean b\u00e0n ph\u00edm ch\u00ednh) <\/strong>\u0111\u1ec3 hi\u1ec7n ra h\u1ed9p tho\u1ea1i <strong>Delete <\/strong>cho ph\u00e9p\u00a0 b\u1ea1n ch\u1ecdn n\u00fat <strong>Entire row<\/strong> (to\u00e0n b\u1ed9 h\u00e0ng) ho\u1eb7c b\u1ea5t k\u1ef3 t\u00f9y ch\u1ecdn x\u00f3a n\u00e0o kh\u00e1c b\u1ea1n mu\u1ed1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Xoa_hang_neu_co_du_lieu_o_ben_phai_bang\"><\/span><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5451 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-49.png\" width=\"188\" height=\"184\" title=\"excel-find-replace-highlight-49\"><strong>X\u00f3a h\u00e0ng n\u1ebfu c\u00f3 d\u1eef li\u1ec7u \u1edf b\u00ean ph\u1ea3i b\u1ea3ng<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>Ctrl + \u2013 (tr\u1eeb tr\u00ean b\u00e0n ph\u00edm ch\u00ednh)<\/strong> Ph\u00edm t\u1eaft Excel l\u00e0 c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 x\u00f3a h\u00e0ng. Tuy nhi\u00ean, n\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u n\u00e0o \u1edf b\u00ean ph\u1ea3i b\u1ea3ng ch\u00ednh c\u1ee7a b\u1ea1n nh\u01b0 tr\u00ean h\u00ecnh b\u00ean d\u01b0\u1edbi, n\u00f3 c\u00f3 th\u1ec3 x\u00f3a lu\u00f4n c\u00e1c d\u1eef li\u1ec7u c\u00f3 th\u1ec3 b\u1ea1n mu\u1ed1n gi\u1eef l\u1ea1i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5452 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-50.png\" width=\"580\" height=\"184\" title=\"excel-find-replace-highlight-50\"><\/p>\n<p>N\u1ebfu g\u1eb7p tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh d\u01b0\u1edbi d\u1ea1ng B\u1ea3ng Excel.<\/p>\n<p>1. Nh\u1ea5n <strong>Ctrl + T<\/strong> ho\u1eb7c v\u00e0o tab <strong>Home -&gt; Format<\/strong> <strong>as Table<\/strong> v\u00e0 ch\u1ecdn ki\u1ec3u ph\u00f9 h\u1ee3p nh\u1ea5t.<\/p>\n<p style=\"text-align: left\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/New-Bitmap-Image-2.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5479 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-4.bmp\" width=\"453\" height=\"184\" title=\"new-bitmap-image-2-4\"><\/a><br \/>\nB\u1ea1n s\u1ebd th\u1ea5y h\u1ed9p tho\u1ea1i <strong>Create Table<\/strong> m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u kho\u1ea3ng c\u1ea7n thi\u1ebft.<\/p>\n<p style=\"text-align: left\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/New-Bitmap-Image-2-1.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5481 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-1-1.bmp\" width=\"513\" height=\"243\" title=\"new-bitmap-image-2-1-1\"><\/a>2. B\u00e2y gi\u1edd d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng, h\u00e3y ch\u1ecdn v\u00f9ng gi\u00e1 tr\u1ecb ho\u1eb7c h\u00e0ng b\u1ea1n mu\u1ed1n x\u00f3a trong b\u1ea3ng c\u1ee7a m\u00ecnh.<\/p>\n<p class=\"aligncenter\" style=\"text-align: left\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/New-Bitmap-Image-2-8.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5502 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-8-1.bmp\" width=\"600\" height=\"209\" title=\"new-bitmap-image-2-8-1\"><\/a><br \/>\n<strong>Ch\u00fa \u00fd<\/strong>. H\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n kh\u00f4ng s\u1eed d\u1ee5ng c\u00e1c n\u00fat h\u00e0ng \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 h\u00e0ng.<\/p>\n<p>3. Nh\u1ea5n <strong>Ctrl + \u2013 (tr\u1eeb tr\u00ean b\u00e0n ph\u00edm ch\u00ednh)<\/strong> \u0111\u1ec3 x\u00f3a d\u1eef li\u1ec7u kh\u1ecfi b\u1ea3ng c\u1ee7a b\u1ea1n. C\u00e1c th\u00f4ng tin b\u1ed5 sung \u1edf b\u00ean ph\u1ea3i s\u1ebd \u0111\u01b0\u1ee3c gi\u1eef nguy\u00ean.<\/p>\n<p>Hy v\u1ecdng b\u1ea1n th\u1ea5y c\u00e1ch x\u00f3a h\u00e0ng n\u00e0y h\u1eefu \u00edch. H\u00e3y ti\u1ebfp t\u1ee5c \u0111\u1ecdc \u0111\u1ec3 bi\u1ebft c\u00e1ch d\u00f9ng Excel VBA \u0111\u1ec3 x\u00f3a c\u00e1c h\u00e0ng v\u00e0 t\u00ecm hi\u1ec3u l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 b\u1ecf d\u1eef li\u1ec7u d\u1ef1a tr\u00ean v\u0103n b\u1ea3n nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Xoa_cac_hang_co_chua_du_lieu_dinh_trong_mot_cot\"><\/span><strong>X\u00f3a c\u00e1c h\u00e0ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u \u0111\u1ecbnh trong m\u1ed9t c\u1ed9t<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu c\u00e1c m\u1ee5c trong h\u00e0ng b\u1ea1n mu\u1ed1n x\u00f3a xu\u1ea5t hi\u1ec7n ch\u1ec9 trong m\u1ed9t c\u1ed9t, c\u00e1c b\u01b0\u1edbc sau s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n qu\u00e1 tr\u00ecnh xo\u00e1 c\u00e1c h\u00e0ng ch\u00fang.<\/p>\n<p>1. \u0110\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n d\u00f9ng <strong>Filter<\/strong> \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u b\u1ea3ng c\u1ee7a m\u00ecnh. \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, \u0111\u1ebfn tab Data, ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng Filter.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5458 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-55.png\" width=\"600\" height=\"113\" title=\"excel-find-replace-highlight-55\"><\/p>\n<p>2. L\u1ecdc c\u1ed9t c\u00f3 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n x\u00f3a d\u1ef1a v\u00e0o c\u00e1c t\u00f9y ch\u1ecdn. Nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean b\u00ean c\u1ea1nh c\u1ed9t ch\u1ee9a c\u00e1c m\u1ee5c c\u1ea7n l\u1ecdc. Sau \u0111\u00f3 b\u1ecf ch\u1ecdn <strong>Select All<\/strong> c\u1ea3 v\u00e0 \u0111\u00e1nh d\u1ea5u h\u1ed9p ki\u1ec3m b\u00ean c\u1ea1nh c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n l\u1ecdc. N\u1ebfu danh s\u00e1ch d\u00e0i, ch\u1ec9 c\u1ea7n nh\u1eadp v\u0103n b\u1ea3n c\u1ea7n l\u1ecdc v\u00e0o Sau \u0111\u00f3 b\u1ea5m OK \u0111\u1ec3 x\u00e1c nh\u1eadn.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-filter-column-text.png\" alt=\"Filter the column by the needed text\" title=\"excel-filter-column-text\"><\/p>\n<p>3. Ch\u1ecdn c\u00e1c \u00f4 \u0111\u01b0\u1ee3c l\u1ecdc trong c\u00e1c h\u00e0ng m\u00e0 b\u1ea1n mu\u1ed1n x\u00f3a. Kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u1ecdn to\u00e0n b\u1ed9 h\u00e0ng.<\/p>\n<p>4. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u v\u00e0 v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn <strong>Delete Row<\/strong> t\u1eeb danh s\u00e1ch tr\u00ecnh \u0111\u01a1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5461 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-replace-highlight-57.png\" width=\"457\" height=\"281\" title=\"excel-find-replace-highlight-57\"><\/p>\n<p>Cu\u1ed1i c\u00f9ng nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Filter m\u1ed9t l\u1ea7n n\u1eefa \u0111\u1ec3 h\u1ee7y tr\u1ea1ng th\u00e1i l\u1ecdc d\u1eef li\u1ec7u v\u00e0 th\u1ea5y r\u1eb1ng c\u00e1c h\u00e0ng v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng c\u1ea7n bi\u1ebfn m\u1ea5t kh\u1ecfi b\u1ea3ng c\u1ee7a b\u1ea1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Excel_VBA_Macro_de_xoa_hang_hoac_loai_bo_moi_hang_khac\"><\/span><strong>Excel VBA Macro \u0111\u1ec3 x\u00f3a h\u00e0ng ho\u1eb7c lo\u1ea1i b\u1ecf m\u1ecdi h\u00e0ng kh\u00e1c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n lu\u00f4n t\u00ecm ki\u1ebfm m\u1ed9t gi\u1ea3i ph\u00e1p \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y ho\u1eb7c th\u1ef1c hi\u1ec7n c\u00e1c th\u1ee7 t\u1ee5c Excel, h\u00e3y ch\u1ecdn c\u00e1c macro b\u00ean d\u01b0\u1edbi \u0111\u1ec3 x\u00f3a h\u00e0ng. Trong ph\u1ea7n n\u00e0y, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y 2 VBA Macro gi\u00fap b\u1ea1n lo\u1ea1i b\u1ecf c\u00e1c h\u00e0ng v\u1edbi c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn ho\u1eb7c x\u00f3a nh\u1eefng h\u00e0ng kh\u00e1c trong Excel.<\/p>\n<p>Macro <strong>RemoveRowsWithSelectedCells<\/strong> s\u1ebd lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng ch\u1ee9a \u00edt nh\u1ea5t m\u1ed9t \u00f4 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u.<\/p>\n<p>Macro <strong>RemoveEveryOtherRow<\/strong> s\u1ebd gi\u00fap b\u1ea1n x\u00f3a h\u00e0ng th\u1ee9 hai \/ th\u1ee9 ba, vv, theo c\u00e1c thi\u1ebft l\u1eadp c\u1ee7a b\u1ea1n. N\u00f3 s\u1ebd lo\u1ea1i b\u1ecf c\u00e1c h\u00e0ng b\u1eaft \u0111\u1ea7u v\u1edbi v\u1ecb tr\u00ed con tr\u1ecf chu\u1ed9t hi\u1ec7n t\u1ea1i v\u00e0 cho \u0111\u1ebfn cu\u1ed1i b\u1ea3ng c\u1ee7a b\u1ea1n.<\/p>\n<div>\n<div id=\"highlighter_551811\" class=\"syntaxhighlighter nogutter vb\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"vb keyword\">Sub<\/code> <code class=\"vb plain\">RemoveRowsWithSelectedCells()<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">rngCurCell, rng2Delete <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Range<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Application.ScreenUpdating = <\/code><code class=\"vb keyword\">False<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Application.Calculation = xlCalculationManual<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">For<\/code> <code class=\"vb keyword\">Each<\/code> <code class=\"vb plain\">rngCurCell <\/code><code class=\"vb keyword\">In<\/code> <code class=\"vb plain\">Selection<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">If<\/code> <code class=\"vb keyword\">Not<\/code> <code class=\"vb plain\">rng2Delete <\/code><code class=\"vb keyword\">Is<\/code> <code class=\"vb keyword\">Nothing<\/code> <code class=\"vb keyword\">Then<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">rng2Delete = Application.Union(rng2Delete, _<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">ActiveSheet.Cells(rngCurCell.Row, 1))<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Else<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">rng2Delete = rngCurCell<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">If<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Next<\/code> <code class=\"vb plain\">rngCurCell<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">If<\/code> <code class=\"vb keyword\">Not<\/code> <code class=\"vb plain\">rng2Delete <\/code><code class=\"vb keyword\">Is<\/code> <code class=\"vb keyword\">Nothing<\/code> <code class=\"vb keyword\">Then<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">rng2Delete.EntireRow.Delete<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">If<\/code><\/div>\n<div class=\"line number19 index18 alt2\"><\/div>\n<div class=\"line number20 index19 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Application.ScreenUpdating = <\/code><code class=\"vb keyword\">True<\/code><\/div>\n<div class=\"line number21 index20 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Application.Calculation = xlCalculationAutomatic<\/code><\/div>\n<div class=\"line number22 index21 alt1\"><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">Sub<\/code><\/div>\n<div class=\"line number23 index22 alt2\"><\/div>\n<div class=\"line number24 index23 alt1\"><\/div>\n<div class=\"line number25 index24 alt2\"><code class=\"vb keyword\">Sub<\/code> <code class=\"vb plain\">RemoveEveryOtherRow()<\/code><\/div>\n<div class=\"line number26 index25 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">rowNo, rowStart, rowFinish, rowStep <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb keyword\">Long<\/code><\/div>\n<div class=\"line number27 index26 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Dim<\/code> <code class=\"vb plain\">rng2Delete <\/code><code class=\"vb keyword\">As<\/code> <code class=\"vb plain\">Range<\/code><\/div>\n<div class=\"line number28 index27 alt1\"><\/div>\n<div class=\"line number29 index28 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">rowStep = 2<\/code><\/div>\n<div class=\"line number30 index29 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">rowStart = Application.Selection.Cells(1, 1).Row<\/code><\/div>\n<div class=\"line number31 index30 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">rowFinish = ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row<\/code><\/div>\n<div class=\"line number32 index31 alt1\"><\/div>\n<div class=\"line number33 index32 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Application.ScreenUpdating = <\/code><code class=\"vb keyword\">False<\/code><\/div>\n<div class=\"line number34 index33 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Application.Calculation = xlCalculationManual<\/code><\/div>\n<div class=\"line number35 index34 alt2\"><\/div>\n<div class=\"line number36 index35 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">For<\/code> <code class=\"vb plain\">rowNo = rowStart <\/code><code class=\"vb keyword\">To<\/code> <code class=\"vb plain\">rowFinish <\/code><code class=\"vb keyword\">Step<\/code> <code class=\"vb plain\">rowStep<\/code><\/div>\n<div class=\"line number37 index36 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">If<\/code> <code class=\"vb keyword\">Not<\/code> <code class=\"vb plain\">rng2Delete <\/code><code class=\"vb keyword\">Is<\/code> <code class=\"vb keyword\">Nothing<\/code> <code class=\"vb keyword\">Then<\/code><\/div>\n<div class=\"line number38 index37 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">rng2Delete = Application.Union(rng2Delete, _<\/code><\/div>\n<div class=\"line number39 index38 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">ActiveSheet.Cells(rowNo, 1))<\/code><\/div>\n<div class=\"line number40 index39 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Else<\/code><\/div>\n<div class=\"line number41 index40 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Set<\/code> <code class=\"vb plain\">rng2Delete = ActiveSheet.Cells(rowNo, 1)<\/code><\/div>\n<div class=\"line number42 index41 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">If<\/code><\/div>\n<div class=\"line number43 index42 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">Next<\/code><\/div>\n<div class=\"line number44 index43 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">If<\/code> <code class=\"vb keyword\">Not<\/code> <code class=\"vb plain\">rng2Delete <\/code><code class=\"vb keyword\">Is<\/code> <code class=\"vb keyword\">Nothing<\/code> <code class=\"vb keyword\">Then<\/code><\/div>\n<div class=\"line number45 index44 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">rng2Delete.EntireRow.Delete<\/code><\/div>\n<div class=\"line number46 index45 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb comments\">' Hide every other row<\/code><\/div>\n<div class=\"line number47 index46 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb comments\">'rng2Delete.EntireRow.Hidden = True<\/code><\/div>\n<div class=\"line number48 index47 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">If<\/code><\/div>\n<div class=\"line number49 index48 alt2\"><\/div>\n<div class=\"line number50 index49 alt1\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Application.ScreenUpdating = <\/code><code class=\"vb keyword\">True<\/code><\/div>\n<div class=\"line number51 index50 alt2\"><code class=\"vb spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"vb plain\">Application.Calculation = xlCalculationAutomatic<\/code><\/div>\n<div class=\"line number52 index51 alt1\"><code class=\"vb keyword\">End<\/code> <code class=\"vb keyword\">Sub<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<div class=\"_4tdt _ua1\">\n<div class=\"_ua2\">\n<div class=\"_4tdv\">\n<div class=\"_5wd4 _1nc7 direction_ltr\">\n<div class=\"_h8t\"><\/div>\n<p>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<a href=\"http:\/\/bit.ly\/2OAUBOg\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. 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. Chi ti\u1ebft xem t\u1ea1i:\n<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\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-308.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7620,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7619","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\/7619","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=7619"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7619\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7620"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7619"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7619"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7619"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}