delete columns

  1. S

    Deleting Blank Columns

    Can anyone give me a clue as to what I need to do to search for blank columns in a range and delete them? I can do this for blank rows, but am stuck on deleting blank columns. Here is the code I have started for the blank rows, but am lost on the columns section. For a = 1 To lastrow...
  2. A

    Right border is removed when I delete columns

    Hi All, I have a table that has thin borders around all four sides of the cells in a column. My column is in the middle of the table and I have to delete the columns so that now this column is the last column in the table. After I delete the columns to the right I lose the borders on the right...
  3. S

    Deleting non-contiguous columns based on column number

    Hey everyone, I'm having a little trouble. I was able to select one group that I wanted to delete based on the column number because I am using a variable: Range(Columns(10), Columns(testint - 10)).Select Selection.Delete Shift:=xlToLefttestint is just the number of columns in the sheet But I...
  4. W

    Find text in string and delete columns without the text

    I have a sheet where (starting at column E), each alternate column has a header. eg E F G H etc..... 31_02_Datannn (blank) 31_02_Field (blank) I need code which (starting at column E)...
  5. W

    Delete partial column and shift left

    Hey guys, So this is my first VBA project I've ever done. But what I need is to go through about 50 worksheets and delete partially blank columns and shift the full columns to the left. I pull this data from PDF files and it is causing this formatting error. However, it also sometimes pulls...
  6. S

    Delete

    Sir, who to delete rows and colomuns permanently. Suppose: I have work in only a1 to g150, now i want see only a1 to g150 colomuns and rows only.
  7. J

    Code to find a record and delete the entire column which its in

    Hi i need some code that pops up a box, allowing you to input a name which searches all sheets of a workbook and then deletes the entire column which it is found in.. I need it to prompt whether to delete it or not before it does!! Please help Thanks
  8. A

    Delete a large number of rows and columns

    I recently joined a new team at work who uses a spreadsheet to track savings. It is shared between multiple users. The problem is that for some reason, at some point, someone decided to copy the formatting all the way down to row 65536 and row IV. If you try to manually delete say 1000 blank...

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