count row

Hi There , im really new to macro scripting. I have a word repeated in column 1, called "project:". once identified i need to count down and delete rows as per the following: count down 9 rows from the project row (and check if the column 1 word is "ID kV" if yes, delete that 10 rows...

Hi I have this macro where it selects a range tehn copy and paste it on another sheet, but I would like to do it on the last row, is that possible? Sub CopiaDetalle() Ultimafila = Worksheets("U-Detail").Range("C" & Rows.Count).End(xlUp).Row UltimafilaD = Worksheets("Detail").Range("C" &...

Hi, I have this code to insert my formula and fill down the column. wsFirst.Range("AQ3:AQ" & Cells(Rows.Count, 1).End(xlUp).Row).Formula = "=IF(P19=1,1,0)" The problem is that it stops at 101'st row. I think this is related to the fact that before i created the range "ipi" with 101 values...

I want to count the number of rows that have a specific number of populated cells. For example looking at the table below, I want to know the number of rows that have "Yes" exactly 2 times. I only care about text though that's in columns C, D, E, and F (A, B, G, and H should not be included in...

Hello, Can someone assist me to identify a macro that will count non blank row from a particular row to the next blank row in the middle of the sheet. Sample below [Column A] [Row 1] Not Needed [Row 2] Not Needed [Row 3] Blank Cell [Row 4] Needed [Row 5] Needed [Row 6] Needed [Row...