Ignoring Formulas When Searching For Next Empty Cell

[ExcelAtEverything]

Hello! The following was created to find the next empty cell within a range in column B, and then paste in info which was copied from O6:P6. The only problem is that it's not working correctly because I have cells in column B which contain formulas (fitted with an IFERROR prefix to keep some cells empty when there is no info to fill them). How can I edit this to ignore cells containing formulas in column B when looking for the next empty?

Sub AddExtraStoreToLocMasterList() '
' AddExtraStoreToLocMasterList Macro
' This macro copies O6:P6 to cipboard, then finds first blank cell in column B Loc Master List range, and the paste specials there.
'
Range("O6:P6").Select
Selection.Copy
Range("B4").Select
ActiveCell.End(xlDown).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("O6:P6").Select
Application.CutCopyMode = False
Selection.ClearContents
Range("O6").Select
End Sub

 

[Rick Rothstein]

I thought you were looking to find blank cells without formulas? What exactly did you mean when you said "How can I edit this to ignore cells containing formulas in column B when looking for the next empty?"? I am kind of confused at what you are trying to do. Are you simply looking for the blank cell just below the last formula in Column B?

 

[ExcelAtEverything]

I'm looking for the next visibly bank cell, after the visiby occupied cells (which show as having contents). That said, if there are no visible contents, then it will contain a formula. It's ok to paste over the formula. The reason this is not an issue is because the sheet is a one-time-use sheet, then you start from scratch again the next day with a fresh... original sheet.