macros auto delete

  1. K

    VBA code to delete copied blank cells

    Hi, I'm doing a macro that copies a specific range and then pastes it on another sheet to make a database. This range contains blank cells and also another ones that have a formula that if a cell is blank, then the value of the cell's formula is blank. If(B7="","",.....). the range that I copy...
  2. T

    Deleting Columns Via Macro

    Hi, Hope someone can assist me, i have am new to the whole macro/formula experience and have spent 5 hours today trying different methods of trying to do this. I have to run reports every week and need to streamline how long it take me to do, so i want to delete out columns in excel that i do...
  3. oldeirish

    Dynamic Range in VBA and Auto Deleting Unwanted Imported Data By Name

    Hi, I have created a Macros to input data (from external source) through recording a macro. Since it is a weekly update, the data varies in size. How do I change the area in which the data can still be totalled and also delete lines that begin with "Total" instead of "Company" name? Sub...
    • oldeirish
    • Thread
    • dynamic range formulas macros macros auto delete vba - help
    • Replies: 0
    • Forum: Excel Questions
  4. E

    VBA/Macros - How to auto delete data from cell if cell begins with

    I would like to see if someone can help me with a macros formula. I need to delete cell values if a cell begins with a certain number. Delete all cell values for B22 through D65536 IF cell in C22 through C65536 begins with 3.00, 4.00, 5.00 AND Delete all cell values for G22 through I65536 IF...

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