vba delete columns' data

  1. M

    Vba code required to delete columns

    I'm looking for a vba code that will hopefully delete multiple columns preferably (or ranges) based on a cell value (0 in this case). What you see in the image is a front and back page.In my worksheet there are 40 pages but only need to print the ones that don't have 0. In the scenario in the...
  2. U

    VBA: Delete Columns with Images

    Hi Gurus, I have some columns that I need to delete however, there are embedded picture image in cells. I tried using below code but the picture are still visible. = = = = Sub Delete() Worksheets("Sheet1").Activate Columns("C:C").Delete Columns("X:Z").Delete End Sub = = = = Is...
  3. U

    VBA: Delete Entire Columns based on Header value in Excel

    Hi Gurus, Good day! I found below code in deleting specific column. However, I want to apply it for all tab sheets. Suppose I have 15 sheets. = = = Sub DeleteSpecifcColumn() Dim xFNum, xFFNum, xCount As Integer Dim xStr As String Dim xArrName As Variant Dim MR, xRg As Range On Error Resume...
  4. M

    VBA to delete columns A through to D on a specific Worksheet

    Pretty much what the title says: Need a command button on a worksheet that runs code to delete all data in Columns A through D (incl) on "Sheet4" as a way to cleanse the workfile for additional data import. Note that there are formulas on "Sheet4" in columns E through U that reference the data...

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