I need macro to delete entire row or col I really appreciate your help! Thanks!
P papou Jul 8, 2004 #2 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
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
A Alan Beban Jul 8, 2004 #3 "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
"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
