remove columns

  1. O

    Delete columns if headers contains "A, B... or Z"

    Hi, My name's Oliver and I'm currently writing my university thesis and need help with sorting out a lot of data. Have several worksheets, where every worksheet contains between 1000-7500 columns with headers and data below. I want to delete the columns that contain certain texts (like...
  2. X

    Macro to remove certain columns depending on selected items

    Hello, On a sheet (first_sheet), i have activex comboboxes on a grid that contains values of sheets/columns, so that for each sheet if YES is selected nothing happens, but when NO is selected, these columns must be removed automatically from these sheets right after their generation. Now the...
  3. D

    Excel 2007 Button to add more rows to table

    Hello there, This is my 1st time trying to code in VBA. I have a table (with formatting) with 8 columns on sheet 1 of my workbook in Excel 2007. I have created a button that when clicked it adds 37 rows to my table (just enough to add another page for printing). Below is my code Sub...
  4. T

    Multiselect listboxes

    Hello - I would greatly appreciate some help with a problem I have come across. I have a form that has two listboxes and listbox1 is populated with the column headers in my worksheet. I want to be able to have the user select columns on the left and "add" them to listbox2. Here is the code...

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