deleting rows vba

  1. A

    Macro to removed rows with exact text

    I'm trying to create a macro which allow me to remove a row if it contains an exact word. When I extract data, the column may contain the word "Renewal" or "Renewal & Additional". What I'm trying to achieve is to remove all the rows that contain the word "Renewal" and not the rows that contain...
  2. Z

    Run-Time error and crash after deleting a row in a table in vba

    MR. Excel Help Hi all, I am having trouble with a delete row macro for one of my tables in excel. When I run my "Call_Delete_Row" code in an existing table after I open my excel spreadsheet, the last row for two tables on two different sheets are deleted. However, AFTER I run...
    • ZStaebler
    • Thread
    • deleting rows vba run-time error tables tables vba for/next tables;range names
    • Replies: 0
    • Forum: Excel Questions
  3. S

    Insertig/deleting rows in VBA

    Hi guys, I was wondering if anyone could help me with this? I would like a macro to block users of a shared spreadsheet from inserting/deleting rows without protecting it. So in essence they should be able to amend anything on it apart from inserting or deleting rows? Could anyone help me out...

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