1. L

    delete empty space

    Hello! I have a column with many names, the problem is that there is an empty space before and after the name. It will take me a while to delete it manually. Is there a way to get rid of those spaces? " Lavinia Drtcxc " " Mara Fort Dguyutf " . . So one space before and one after. Any ideas...
  2. L

    Find and delete

    Hello! Is it possible to find a part of a word and delete it ? I have a column like : LaviniaAdm as exp AndreeaAdm not there LauraAdm adminansdghjk . . . And so on. A name followed by Adm written together. I have a long list so I don't want to delete it manually. Is there a way to insert a...
  3. A

    VBA to delete HeaderRowRange

    Hi, I just need to delete the header of a table and copy the body range to another worksheet. But not sure what is not right with the code below, it just not able to delete the header. Following is my code. Dim lo As ListObject Workbooks("WIP_Macro.xlsm").Sheets("WIP").Activate Set lo =...
  4. H

    I need an update to this code (Which I copied from an answer on a post here) that could only delete rows that have :01 and :31.

    Sub Del_Non_00() Dim a, b Dim nc As Long, i As Long, k As Long nc = Cells.Find(What:="*", After:=Cells(1, 1), LookIn:=xlValues, SearchOrder:=xlByColumns, _ SearchDirection:=xlPrevious, SearchFormat:=False).Column + 1 a = Range("B1", Range("B" &...
  5. G

    Deleting Columns in spreadsheet if column has not been edited.

    Hi I have a somewhat unusual question in my request here. I have a spreadsheet where columns may be edited and if they have, I need to keep those and delete the rest. So if there were 45 rows, and only 1 of the 45 were edited, that whole column needs to be kept. I have played around with the...
  6. K

    Delete Row when cell contains another cell text

    Hi, very new to this. I need help with finding data from one sheet to finding data in another sheet and deleting that row. I have had a lot of trouble with this and cant seem to crack it. Can anyone help a formula?
  7. K

    VBA: Search for value and select and delete row with that value

    Hello everyone, I want to rearrange some data in an excel table. I have a variable ID_Nr defined as double and it is a number between 2 and 100. I want the macro to look for that number in column A and if found select the whole row and delete it. That way I am trying to eliminate all rows with...
  8. R

    VBA-only delete rows based off cells that is not in another sheet

    Hello, Sheet2 column a has strings that i want to be saved from sheet1 Sheet1 if column H does NOT contain string that is in sheet2 column A then delete row. So basically sheet2 contains the list of what i want to keep in sheet1, everything else delete. sheet2 ColA needs to be dynamic as the...
  9. K

    Delete the entire row if the Date is older than six months

    Hello Experts, I have a worksheet with dates, email addresses and several other data. I am planning to send email notifications based on the date. After sending the notification, keeping that record more than six months is useless. So, what I want to do is to delete the entire row if the Date...
  10. B

    Deleting Rows with VBA

    The code below works as is, but when I there are 40,000 to 50,000 lines of data, it tends to slow down a lot. In the code below, I'm checking for unwanted data in columns A and G. Is there anything I can do to speed this process up? Thanks! Sub DeleteEntireRow() Dim RowToTest As Long With...
  11. G

    VBA - Delete all rows except rows which contain certain text

    Hi All, I have a excel workbook with 2 worksheets. Worksheet A has a very badly formatted data dump from our timesheet tool. Worksheet B has a list of project names. I am looking for a vba code which when run will delete all rows in Worksheet A expect for rows which have dates in them and rows...
  12. G

    Delete "Empty" Cells in Excel

    Hello Everyone, I am trying to delete all the empty cells in my excel document, for sorting purposes. Everyday an excel document is generated with data from one of our systems. The system is capable of storing up to 20,000 values per day and inputs all the data into the file, even "blank"...
  13. F

    Deleting Rows in multiple sheets using VBA

    Hi all, I have a workbook in which i have multiple sheets currently maxed out on line limits. Deleting the lines manually is taking forever so i wrote a macro which will delete any line in which columns B, C, D, F, G and I have a 0 in them. I'm getting an issue where the code only goes to the...
  14. A

    Need To Delete Rows Based On Multiple Criteria

    Hi, I'm knew to this and would appreciate any help provided. I read somewhere that there is a limit to the number of terms that one macro could handle. I need a VBA script to delete multiple rows in column “A” based on if the cell has (ANY) reference of over 150 terms. For example, if I want...
  15. D

    Formula being deleted

    I have a spreadsheet that has a table in it with a formula in a hidden column for the table. I have a button to delete the records but if the row is highlighted and delete button pressed on the keyboard, the formula in the hidden column will be deleted. Is there a way I can add some vba code to...
  16. S

    Macro to move zip file from one location to another, extract, then delete zip if possible

    Hi Can anyone help me by writing a macro that can move a zip file from a specific folder, put it in a new specific folder elsewhere on the drive, extract it in that location, then delete the zip? The delete is the least important part. When it moves it initially it would be best if it was cut...
  17. D

    VBA delete last row help

    Hello everyone. I am trying to piece meal my VBA where I need it to select all sheets in the workbook and delete the last row in each sheet. Each sheet has the same headers but varies in row so as long as it is the last row being deleted it will work. Any pointers would be greatly...
  18. E

    Prevent deletion of last row of excel table

    Hi folks I have an Excel Table with names and abbreviations of names (two columns only). I would like to prevent users from deleting the header row and last row in the table. <tbody> Abbreviation Surname and Initial PM Masters, P JL Leonard, J JM Matsau, J TOTAL 3 [given by...
  19. S

    Delete Rows if contains text in column A

    Hello All, Need a macro to delete rows if text equals to ("BB", "CCC","DDDD") in column A.
  20. S

    VBA Help - "Delete Method of Range class failed"

    Hi folks, i'm getting a Run-Time Error '1004' "Delete method of Range class failed" for the following code. Sub Satisfied() Dim MasterSht As Worksheet Dim ImportSht As Worksheet Dim LastRow As Long Dim x As Long Application.ScreenUpdating = False Set MasterSht = ThisWorkbook.Sheets("Master...

Some videos you may like

This Week's Hot Topics