delete a row

HI i am very new to VBA, I have been working on them but mainly finding them on the net and then pasting and adjusting them to suit. i require help to work out how to delete a row if in column N the time is less than 30mins. Also to note when I paste the data into the excel sheet it is in text...

Hi, I am trying to format an excel file where two rows combine into one row and empty rows are removed. The goal is to insert two columns to the left of the sheet, then CUT the cells in C4:D4 (A4:B4 on the screenshot before two columns were inserted) the highlighted data, where the Part number...

I have an excel worksheet that is set to update the next cells with a date if a value was changed in a cell. This then copies the entire row to another worksheet called Changes if any value in K, M changes In Cell K is the data and in L is the date it was last amended. The same in Cells M & N...

How can I delete an entire row when there is a 0 value is a certain cell, say A1. Thanks for your help

I am looking to write a VBA to delete rows based on a call value within Sheet13. If the value in column A (over 50,000 rows) does not match the cell value in H1, then delete that row. With the amount of rows, I am concerned with the speed and efficiency of the code.

Hello, I am looking for solution to delete rows with event time which I am not intrested in. As for example I would like to delete/clear every rows between time 6:00 AM and 6:05 AM with macro. What is more I would be great if macro would ignore the date and focus only on time because it is...

Hello, I need help with providing the right code. After doing one Macro automation, I would like to delete any rows that have a cell value of "#VALUE!" (which is essentially a computed formula that comes back with that message). Is it possible for it to be done? And keep in mind that this...

I have a worksheet that users input employee names and date of birth for various calculations. A few users are deleting rows that are causing #REF errors with the calculations and I am looking for a solution around it. Indirect or Offset are options I am considering to solve the issue. Here...

Hi, this script copy the entire row into another sheet based on text value in a cell. Copy works fine. However it also delete the row copied from original sheet, and I need it to stay! I need the row to stay and be copied, not copied and deleted. How can I get rid of line "Cell.EntireRow.Delete"...

I have been working in document.docx where I want to open Excel file as object, find some text in this object and delete entire row of found text. I had opened the EMEA CC FINAL LIST.xls successfully but I am getting error in finding the text. I am new to VBA, please help. Dim xC As Object...

Hello All, I have taken over a workbook and it looks absolutely messy. I need to be able to delete rows from the summary sheet of the workbook, without compromising the data on the other sheets. How can I do this?

Hi all. thanks you in advance for your help. I am new at VBA and have been trying to compare 2 lists and add or delete records as needed. Both the lists are in tables of which I also need formulas added. Hopefully the detail below makes it easier to understand. Column B on this sheet is the list...

Sub DeleteSettleHKDDebitAccount() Dim checkrow As Long, lastrow As Long With Worksheets lastrow = Worksheets("借出-港幣").Cells(Rows.Count, "A").End(xlUp).Row For checkrow = 3 To lastrow If Worksheets("借出-港幣").Cells(checkrow, "F") <> "" Then...

Hello All. User makes a series of decisions on an tab INPUTS, which causes tab MODEL AV51:AV163399 to become 1 or 0, depending on user's decisions. User decision may cause as many as all rows to be 1, or as few as, say 20 rows to be 1. What I'd like is a macro that deletes all rows on MODEL...

Hi, I haven't written/recorded a macro in a very very long time and am struggling to try and do something simple. I need to search all worksheets of a file (containing around 100 tabs) for cells which contain the text "_web.pdf". There is also other text in the cells. Then for all cells which...

I have the below VBA code thats faulty to an extent and I was wondering if i could get your expertise to fix my issue. For some reason the code works for exact match to the text but not for the cells that part contains the word i am looking to delete that as well. Sub DataAmendment() FOR...

Hello All, I am trying to delete all rows with a value of "1" in column "Q" (or 17). The issue that I am having is that the code works, kind of, as it deletes the majority of the rows, but skips some rows. My observation is if there are say 5 rows with the following values in column Q (by...

Hi Everyone, I'm building a random name generator for a series of charity prize draws and I'm having a few problems perfecting my code. Basically, I have some VBA code that will search through a single column of names (column a) then select a name at random from the list before displaying the...

Hey guys, I'm new to VBA programming. I have data which contains 6 sheets and all of them has dimension of 9658 rows to A - GK columns. I want to delete each row in every sheet if the value in column C until GK is '@NA' How can I do that in VBA to all of 6 sheets? Thank you.

Hi I'm trying to create a macro whereby a whole row can be deleted if there are blank cells in column B I have the below which works perfect in terms of deleting the rows BUT keeps on running after completing, endlessly going. I have to ESC to stop it. What's wrong? Thanks in advance Sub...