delete row or col
 

I need macro to delete entire row or col

I really appreciate your help! Thanks!

delete row or col
 

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!

delete row or col
 

"EntireRow" and EntireColumn" are superfluous; e.g., Rows("2:2") already
refers to the entire row. Where it would be useful is, e.g.,

Rows("A2").EntireRow.Delete

Alan Beban

papou wrote:

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!