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
Code:
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
Code:
If WorksheetFunction.CountA(bFind.offset(-1,0)) < 1 Then GoTo a: