1. F

    Selecting pictures within highlighted cells

    Hi, I’m trying to delete a picture within a certain number of highlighted cells. I’m trying to do this in VBA and every suggested code I’ve tried doesn’t work or requires specific cells to be selected however I’m highlighting the cells via ActiveCell.Offset codes. The sort of thing I’m after...
  2. Jyggalag

    Use macro to delete files from folder?

    Hi all, I currently have a data overview that draws data through power query from a folder in my windows computer: However, I plan to update this folder rapidly every week and I was wondering if it would be possible to create two macros attached to VBA codes, where they do the following: 1)...
  3. Jyggalag

    Power Query question (never used before!)

    Hi all, I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query. I want to import data into this pivot table (not using power query below): I have the source data saved here: So questionnaire data file 1 is week...
  4. M

    Deleting Data after Extracting

    Hello all, i have created a macro to extract the data from A column except 1st word. But i could not find a way to delete those extracted data from A column. Please guide me to acheive that. Thank you. My macro example. Sub DeLeft() Dim i As Long, d As Long Dim Cel As Range Dim Rng As Range...
  5. H

    vba delete red column in entireworkbook at print area

    hi dear in excel 2019 , Is it possible to have a macro that in my entire workbook in any cell in print area , if red color font used , then delete entire columns . i have not use conditional formating font . please help me .
  6. E

    Delete words in a column based off a list in another column

    How do you delete specific words in one column that's based off a list of words in another column? For example, let's say in column A I have: A1: Carrots are orange. A2: Green peas go great with garlic butter. A3: Watermelons are red on the inside and green on the outside. And in column C are...
  7. G

    Edit imported worksheets

    I have this workbook that imports worksheets and needs to delete Column "F" in each sheet that was imported, without editing any other worksheet in the workbook. The current VBA is below. Thank you in advance for the help. Sub Import() Loop Dim fnameList, fnameCurFile As Variant Dim...
  8. 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...
  9. 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...
  10. 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 =...
  11. 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" &...
  12. 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...
  13. 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?
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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"...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
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 "".
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