empty columns

  1. A

    delete columns that have an empty or blank cell

    What is a faster way of deleting columns that are empty? I am looping thru the first 200 columns to see if each column has data in a specific row. If it is blank, then I want to delete that column. My way takes about 20-30 seconds to run. lastCol = 0 For i = 1 To 200 If...
  2. khawarameer

    Deleting empty columns in a sheet

    Dear All, I have a very large sheet with 250 columns. However some of these columns are empty. I need a script which can delete all empty columns. Can any one help? Regards Khawar
  3. T

    convert last 2 columns to values & add formulas to next column

    Hello! Although I can figure out some of the individual steps, I am having a hard time getting the various parts of this macro to work together. I appreciate any help you can give! There are roughly 500 rows with data and around 50 columns, but the rows could change up or down and 2 columns...
  4. Z

    delete empty rows & columns

    I have a massive spreadsheet, with data range starting from C3. The first 2 rows and columns are the headers. I want to create a macro to delete the rows and columns that are empty at the data range. I appreciate all the help. Thanks, Fan

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