Excel VBA to Delete Row or Column in Excel Table

preview_player
Показать описание
This video tutorial details the VBA code for deleting a row or column within an Excel Table.
------------------------
Рекомендации по теме
Комментарии
Автор

Great information, however a bit incomplete.
I don't know how many rows I have in my table and I want to delete all rows but the header. How do I do that?
Thanks

marcq
Автор

Hi Chester. Thanks for this video. Is there any way to define the column by its header name instead of it's row number? The structure of my table is not fully stable and I would like to prevent my script from breaking after the insertion/removal of other columns.

stugryffin
Автор

Hello,
Very helpful video. I have one question, how to delete all the rows. Thanks

samiijsph
Автор

HI Chester
if i select multiple rows how i can delete

emmanuelalvarado
Автор

Thank you sir, I have 2 questions if you don't mind
1. How can I use this code in multiple sheets with different names.
2. How can I apply this code to multiple sheets.
Thank you again.

abdulhamidalhaddadi
Автор

how to change row 2 with selected, hhmmm for example i klik no 5 then delete the number 5

chairrrul