Hi gv
The macro recorder could also help you achieve this.
Here's a sample code:
Rows("2:2").EntireRow.Delete
Columns("B:B").EntireColumn.Delete

HTH
Cordially
Pascal

"gv" a écrit dans le message de
...
I need macro to delete entire row or col

I really appreciate your help! Thanks!