delete row or col

  • Thread starter Thread starter gv
  • Start date Start date
G

gv

I need macro to delete entire row or col

I really appreciate your help! Thanks!
 
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
 
"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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
convert columns to rows 6
Col widths 3
Help! Can’t debug macro used to delete duplicate rows 2
Macro to hide cols 2
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
UserForm Delete Sheet Columns 2

Back
Top