Clear Cells in a Range

[gheyman]

I have a formula that goes down column Q.

"=IF(AND(INDEX(C25,MATCH(RC15,C[7],0))=TRUE,COUNTA(R3C22:R230C22)=0),RC[-3],IF(AND(INDEX(C25,MATCH(RC15,C[7],0))=TRUE,COUNTIF(R3C22:R230C22,RC[-1])>0),RC[-3],""""))"

I needed to copy paste values from range Q3:Q248 because once I get the formula results, I use an Array formula on the values (And this Array doesn't see " "" " as a blank)

Unfortunately, the copy past value is really a blank either if the formula resulted in " "" ". So now I have to clear the contents where there is " "" ".

I am having a problem with this code

Sub Test()
    Dim lr As Long, cel As Range
 
        lr = Range("Q" & Rows.Count).End(xlUp).Row

        For Each cell In .Range("Q3:Q" & lr)
            If cell = "" Then cell.ClearContents
        Next cell

Next i
End Sub

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1079238-vba-fill-range-array-formula.html#post5184993

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).