macro delete column row

  1. J

    Clear data in a cell using a macro

    Trying to use a macro on excel to clear a column of data containing data, for example B2 down to B1500. I need it so when i click the macro it will clear this selection. Problem is i have another macro doing this on sheet two. But i cant work out how to set up two macros doing the same thing...
  2. A

    Delete Row Automatically

    Hi Guys, I need a small help from you guys, I have a excel file where i am importing data from different files. What i need is to delete the whole row when the user write "Done" on the last column called 'AT'. Like this: Name ID Status Abdul 1 Done Rag 2 Done Roh 3 Undone Zai 4 Done So the...
  3. P

    Deleting rows and columns resulting in black line

    I have a peculiar problem... I am trying to delete the contents of all the rows and columns beyond some row... I am using the below macro for that... The contents are cleared successfully but a black line is produced. Please help !!! Sub CLEAR_REPORT() Sheets("Report").Select...
  4. M

    Deleting a user selected row / column with a macro

    Greetings All, I have created a spreadsheet with macros that will add predetermined # of Rows or Columns. I have assigned these to Macro Buttons and are working fine. I would like to create another macro that will delete columns / rows based on the user selection. Example: I click to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top