delete

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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.
  6. 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...
  7. M

    Delete chart from a specific cell using VBA

    Hi I've used the code below to move a chart from one sheet to another (from Sheet 5 to cell M2 in Sheet 1). However, when re-running the code to create the chart, I would like to delete the existing chart in cell M2 of Sheet 1, without deleting the other charts in Sheet 1. Does anyone know...
  8. P

    Delete entire rows by conditions

    Hi to all of you! Kindly require to provide me support for a VBA code so that to run through columns "O", "P", 'Q" and where the rows are blank or "0" should delete entire rows. Therefore that, the rows "1" - "7" are headings and the code should run from row "8" till rows down. Thank you all in...
  9. N

    Cannot delete page break in Excel

    I have a page break that is making the first page very small, I have tried everything to delete it and nothing works. Heeeellllpppp!!!
  10. I

    Delete Duplicate row based off of email then gender

    Hi all, I searched the forum and found 2 different macros that may work with some tweaking, but is beyond my capabilities. I need the following scenario to happen: 12000 email list has all info from first name, last name, address, gender, age, email and more. The only columns I am concerend...
  11. C

    VBA help

    Hi all, I have some code and I want to delete any rows where the cell in column A is "Yes". Please can someone help? Thanks, Chris
  12. S

    Create a basic macro button for removing specific rows or columns

    Hi all, Apologies for the simple request as a beginner to the forum, but I would like to have a button on a spreadsheet that I can delete either a specific column or row. I have code to remove a column as follows: Sub DeleteColumns() Dim varUserInput As Variant varUserInput = InputBox("Enter...
  13. M

    Deleting specific rows with VBA

    Hi Guys I have data in two columns and would like to delete data in the second column which has the letter 'N' in it, using the auto filter. The amount of rows will vary. In the example below, there are only 5 rows and I would like to delete rows 3 and 4, as they're the rows with the letter...
  14. P

    Delete entire row

    All hi, i am kindly require to provide me a VBA code so that to run through col. "A" and where find the description "NET COST OF SALES/(FOOD)" twice, should delete once entire row but the second one. I present below original data and expected result. Thank you all in advance Original Data...
  15. S

    VBA Coding to select cell under Headings when using filter

    I am using a filter to show all "BB" transactions and delete the rest of the rows that are not "BB". Here is what I recorded when I did it: 'Set autofilter on Column E for "BB" and delete all other rows Range("A1").Select Sheets("PPDR_BB").Select Rows("1:1").Select...
  16. J

    macro to delete all visible rows in an autofilter

    Hi, I have an autofilter on row 13 and then trying to delete all the visible rows I found somewhere that the below code should work, but it doesn't. Anyone who could help me crack the code? Thanks, Jos Rows("13:13").AutoFilter Field:=5, Criteria1:="22 - Rabobank 370113144" .Offset(1...
  17. R

    Remove commented lines

    I have an excel spreadsheet containing many rows copied from VBE. Some of these contain comments - always with a ' in column 1. I would like to delete these lines, but the ' is a hidden character and the program can not find it. Any suggestions, please?
  18. A

    delete row from VBA

    Hi, how can i delete used range in excel after apply filter, without header (First row). i want to do this in VBA. thanks
  19. A

    Macro - Delete Visible Filtered Rows

    Hi all, Happy Friday. I'm trying to record a macro that filters a table to any rows with a "D" in the designated row and then deletes the visible rows, unfiltering the table before ending the macro. I am using the below but it is failing on the "Selection.EntireRow.Delete" command - is anyone...
  20. L

    Pivot Table / Open in New Workbook, Save As, Delete Data.

    Hi All, I am in need of some help here. All the VBA Codes I have tried to use don't work. I am trying to open the information in a pivot table in a new worksheet (I have that part figured out but I cannot get it so it will allow me to add new sheets to my existing workbook every time it opens...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Macro to copy values across rows and transposing them and add the user id
    [FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT] [FONT=Times New...
Top