delete columns

  1. H

    Use search box to extract the relative data from a different worksheet etc

    Hi all, Looking to create a search box with option buttons that once pressed searches a different worksheet for the search box content, then with all rows where this is present, copy them onto a neighboring worksheet and remove a few of the irrelevant columns at the same time. Complete...
  2. L

    delete calculated columns

    I have a borrowed VBA Code that will delete columns that = NR ( =IF((K1=0),"NR",(K2/K1)) ) problem is when the cells shift after deleting ==> the code seems to skip over other NR fields I have attached the code and a small sample of the excel sheet column range can be from H3 to many...
  3. berty2000

    Delete only Columns containing "No"

    In VBA is it possible to delete the whole columns containing the word "No" in the range of C2:AM2 ? Thanks in advance
  4. J

    Delete Columns between Two Specific Columns (based on column heading name)

    Hello, I have a unique situation where I need to delete the columns between two columns. The number of columns between these two will be different at various times... Column_B will always be the second column, but as columns are added in between, "Column_C" will push to the right Here is my...
  5. K

    Help with deleting columns based on conditional formatting please

    I have a spreadsheet with 72 rows and about 10,000 columns. I have applied conditional formatting to highlight all the cells which have a value of less than 150. Is there a way of now deleting all the columns where ALL the cells are highlighted/less than 150? At the moment I have the cells...
  6. M

    Delete same column until value is met !!!

    Hello Everyone! I need a macro keep deleting until the value is met!!! I have this code, but it stops after the first column is deleted instead of deleting the next new Column H until it = Today. How do I get it to Loop? Please, any help...
  7. J

    Macro needed to delete columns where one of two strings not present

    Hi. I regularly receive a spreadsheet that has several hundred columns and a similar number of rows. From column 'D' onwards, the only columns I'm interested in are ones that contain either string "Outstanding" or "Required". Can anyone suggest a macro that would delete all columns after 'D'...
  8. khawarameer

    Deleting Blank Columns in Power Query

    Hello All, I need to import a 256 column table using power query [every fortnight through ODBC]. There are at least 150 columns in the table are empty however there is no fixed criteria that which column would be empty. I order to refine the data i need to delete these empty columns. I used...
  9. A

    VBA- Extend formulas of columns or remove if not needed

    Hello, I am looking for help with a code that will help automate some financial statements. It is a standard tool that has the first year and the last year as an input. Based on the last year of analysis needed, the VBA code would extend (drag) the formulas to the column needed. Also, I built...
  10. M

    VBA Deleting Columns based on cell shading

    Hi All, The worksheets I have, require deleting all columns shaded green on row 13. Up to and including column 150. I have a spreadsheet with headers on row 13, and a few thousand rows of data thereafter. Variable number of columns, starting from 100 to several hundred depending. My problem...
  11. bepedicino

    Looking for assistance to make simple VBA modification

    I need the VBA to delete Column "F" as the very last step in the process. Since I am not familiar with VBA I am looking for help. It would be greatly appreciated if you could assist. Sub valuesAndDelete() With Application .Calculate .ScreenUpdating = False...
  12. S

    Deleting columns based on cell value

    Hi, I have a spreadsheet with a row of dates. I want to be able to put a date in a cell say "A1" and run a macro to delete all columns with dates newer then the date in A1. Thanks
  13. Z

    Simple Code to Delete Range of Columns on All Sheets in WB

    Hello, I have macro now that copies 10 sheets from my workbook and puts them into their own .Xlsx workbook. Once that happens, I want to delete (or clear contents on) a range of columns (P through Z) in all 10 of those sheets (in the new .xlsx file I just made). I must have tried 20 different...
  14. K

    SCREENSHOT INCL. - Fix Macro to Delete Columns whose header is not either "A" or "B"

    I have searched thoroughly the forums on how to keep only columns whose header is the text "x","y" or "c".. and saw a common formula pasted below: Option Explicit Option Compare Text Public Sub DeleteColumns() Dim iLastCol As Long Dim iPtr As Long iLastCol = Cells(1...
  15. U

    Macro: Deleting unneeded columns from exported CSV file

    Hi All, I am a complete noob at macros and have searched high and low for the answer to this question and would be eternally grateful to anyone who can help me out with this. I have an exported CSV file that has many unneeded columns that need to be removed. I also want to split a column so...
  16. J

    Know if specific columns were deleted

    Hi I have a worksheet_change event that I want to put in place but I am having problems ensuring that this event exits if columns A to E are accidentally deleted. I had the same problem with my code if a row was inserted but I started the event with the following: Public Sub...
  17. L

    Delete Method of Range Class Failed, Run-time Error 1004

    Hi everyone, This is my first post so I hope someone can help me out. The VBA macro that I have written is essentially a glorified transpose function (the specifics shouldn't be important for my question). Midway through the code I need to delete a large range of cells so that a) the formatting...
  18. O

    Delete empty Column with heading VBA

    Hi all again, I am am wanting to delete the entire column if there are no entires below the heading in Row 1. So in image below, Col C, E & G are to be delete including the heading. Thanks again everyone Cheers, O
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top