Hello - I am trying to write a code that looks for certain values, and when it finds the first occurrence it creates a blank row. BUT if macro is ran again, it looks for empty rows and skips or jumps the code that makes empty row. It is working in part, but the line checking for a blank row is NOT working.
I want to add more but it requires the following line to work:
Can anybody help - thanks - JA
Sub Insert_Blank_Rows_andBORDER() Dim Lastrow, bFind As Range Dim Ca As Long Dim i As Integer For i = 2 To 5 Lastrow = Cells(Rows.Count, 3).End(xlUp).Row Set bFind = ActiveSheet.Range("C5:" & "C" & Lastrow).Find(What:="B" & i, LookIn:=xlValues, LookAt:=xlPart) If bFind Is Nothing Then GoTo a: [B]If WorksheetFunction.CountA(bFind.Offset(-1,0)) = 0 Then GoTo a:[/B] '''''''If bFind.Offset(-1,0) = "" Then GoTo a: (this doesn't work either) bFind.EntireRow.Insert shift:=xlUp 'Rows(bFind.Row - 1).RowHeight = 9 a: Next i
If WorksheetFunction.CountA(bFind.offset(-1,0)) < 1 Then GoTo a: