Checking if row is empty so as to jump code

jimayers

Board Regular
Joined
Nov 14, 2010
Messages
99
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.
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
I want to add more but it requires the following line to work:
Code:
If WorksheetFunction.CountA(bFind.offset(-1,0)) < 1 Then GoTo a:
Can anybody help - thanks - JA
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Forum statistics

Threads
1,215,032
Messages
6,122,770
Members
449,095
Latest member
m_smith_solihull

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top