delete range

Hi guys, I trying to start using VBA to automatize some task at work, I haved found a code that opened all files in a folder, and works pretty well, but now I need the following: Delete rows 1 to 3 and 6 to 7 mantain rows 4 and 5 Then look for an specific words "MONEDA NACIONAL", on the first...

Hi & happy new year! I have some rows looking like this: 1 4 5 2 12 0 11 1 0 1 1 0 1 0 1 0 1 1 1 1 4 1 0 14 3 What i need is a way to run a macro where it finds the rows in range A:E that contain only combination of "0" and "1" in any sequence and then deleting...

Hello, I know this has been asked before, but I can't get any of the examples to work for my data. I have data in columns A:D. I need to check column D and if cell is 0 (a result of a formula) then delete A:D of that row and shift up. Then go to next. I only want to delete columns A to D...

I have a range in cells A3:O19 named 'Report'. I am hoping to add two form control buttons, one to add a blank copy of that range starting in the first cell below the range above it, and one button to delete the last range on the page. Below is an image of roughly what I am looking for. If I...

I have a spreadsheet that users can only modify through userforms. One userform is meant to allow users to select entire rows of the spreadsheet and delete the data. My current code works when one row is selected or when one contiguous block of rows is selected, but fails when several non...

Hello, I would be grateful for some assistance as I am a VBA novice. I have a spreadsheet broken out into about 30 4-row ranges, for example (A10:L13). All of the ranges use a using a vlookup argument: =IFERROR(VLOOKUP($A10,Fund_Range,2,FALSE),"") in the second row. Around 15 of the ranges...

What i need is for the command button to sort through all my worksheets of info (16 so far) match the information in my userform2.name2 text box and delete that row. It needs to do this for each worksheet. This code below already does most of that. However, it has a glitch. if it does not find...

I'm using the below code, but I need to edit it where I can delete The cells of the row with XXXX in a specific column from column A:AW. I have some data in other columns that I need to not delete. So basically if I2 = "XXXX" then delete A2:AW2 and shift up. Sub Update3() Dim Firstrow...