delete columns faster

  1. 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...
    • unknownymous
    • Thread
    • array a value delete columns delete columns faster delete header vba delete columns' data
    • Replies: 4
    • Forum: Excel Questions
  2. B

    Delete row if containing a certain text Value

    Hi, I'm looking at stock data over the past 20 years and some companies have missing data. This is showing as 'N/A' Id like to delete the entire column if any cell contains an 'N/A'. I've tried to do this through the F5 function but this only selects the individual cell and not the entire...
  3. M

    Deleting multiple columns based on cell contents

    Hi All, Was directed here by someone after not being able to find a solution online. I have an Excel report that gets sent through to me every week and I always have to unmerge the top two rows so all headings are unmerged and then delete all columns containing the words "Ex VAT", "Inc VAT"...
    • miraj42
    • Thread
    • columns delete columns faster time vat vba & excel 2016
    • Replies: 2
    • Forum: Excel Questions
  4. C

    Create a Excel Macro to delete Tabs and columns based on names of Tabs

    I need a macro that deletes all tabs not named "Address," "Phone Number," and "Birth Date" (there will are varying tab names depending on the report, so i want this macro to work regardless of how many and the names of the other tabs [if possible]. I would also like it if one of the above stated...
  5. CarlosTapas

    Deleting columns - faster vba code?

    Hi (Long time reader first time poster) As part of a Macro I export a range of cells that I calculate. I export range A19:DW242 again and again so that it becomes a long dataset of about 70,000+ rows in a seperate sheet.. A then need to “clean” this data by deleting columns that are not...

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