delete a range of rows

  1. D

    Need a Macro to Delete Cell and Shift Cells up

    So here's the situation... I've set up web queries for historical data from Yahoo Finance (so that way I can run automate updates on the data set). There's two web queries to upload two sets of data - 1 for the historical prices of an index, and the other for the historical prices of the ETF...
  2. V

    vba code to delete duplicate rows in range causing error 1004

    I am trying without success to write a vba procedure to delete a duplicate range of cells. The object of the procedure is to define one range of cells and if the code finds a match it should delete the range that matches. This worksheet was imported data from a text file. The error is happening...
    • vba317
    • Thread
    • delete a range of rows delete duplicates match excel & vba excel & vba 2010
    • Replies: 5
    • Forum: Excel Questions
  3. V

    vba code to delete duplicate rows in range causing error 1004

    I am trying without success to write a vba procedure to delete a duplicate range of cells. The object of the procedure is to define one range of cells and if the code finds a match it should delete the range that matches. This worksheet was imported data from a text file. The error is happening...
    • vba317
    • Thread
    • delete a range of rows delete duplicates match excel & vba excel & vba 2010
    • Replies: 1
    • Forum: Excel Questions
  4. P

    Formula or Macro to compress worksheet

    Hi Excel Wizards. Does anyone know of a formula, array processes or macros that will delete rows to compress the worksheet? See the example below. This is the amortization schedule for a $5000 loan. Occasionally on some loans I will make additional Principal payments. As you will see the...

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