deleting a row

  1. A

    Formula Range Changes When Deleting Rows.

    I have a file for tracking where certain loans are while I maintain them. I use sum() and count() formulas to help me make sure I have everything. But what happens is after some time of deleting rows the range in the formulas no longer captures all the data and they need to be readjusted...
  2. 2

    Run-Time Error 1004 - Select method of range class failed

    Hello, I am extremely new to VBA. I am trying to do something very simple and I am running into this error. In my Excel Workbook, there are several sheets. The ones of interest are named "CAR Daily Report Macro" and "CAR Daily Report." I am setting up a macro to copy and paste data from another...
    • 2000km12
    • Thread
    • deleting a row macro - all sheets selecting cells sheets vba error 1004
    • Replies: 5
    • Forum: Excel Questions
  3. E

    Deleting Entire Row if a Cell Located in Column A contains "1"

    Hey everyone, I searched for a solution on this but I didnt find anything that works for me. The Commandbutton for this is located in Sheet 1 and i want the VBA Code to delete every row that contains "1" in Sheet 3, If ActiveSheet.CheckBox1 = False Then 'This is where I need the Code to work
    • eagerbeav3r
    • Thread
    • checkbox activex deleting a row deleting row containing certain text help basic vba
    • Replies: 11
    • Forum: Excel Questions
  4. R

    How can I delete every 3rd row/add 'by'/combine ever two rows (besides doing it manually)

    Hi, I have data that has this format: <Book Title> <Author> <Purchase Date> (repeat...) Here's a sample (the first 2 sets where the above format is a set): The Wrong Side of Goodbye Michael Connelly November 22, 2016 The Jewel of Dantenos Brian D. Anderson November 16, 2016 It's a long...

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