Apply a formula to only visible cells in column O

[Knockoutpie]

Hi everyone,

can someone help me come up with something to apply a formula to the first visible cell under the header in Column O, and then apply that formula down to the end of data for visible cells only?

With ActiveSheet.Range("O2:O" & Cells(Rows.Count, 2).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
.Cells.FormulaR1C1 = ActiveCell.Formula2R1C1 = "formulahere"
End With

currently I am using this which has always worked for me in the past ^, however with my formula which is pulling data from a sharepoint directory, the result return FALSE using this method.

Appying the formula without this returns correct results.

 

[DanteAmor]

Try this:

  With ActiveSheet.Range("O2:O" & Cells(Rows.Count, 2).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
    .Formula = "formulahere"
  End With

It would also be helpful if you put the formula you have in the cell to test it in the macro.

But try it, if you have questions, don't hesitate to ask me.

Dante Amor

 

[Knockoutpie]

Try this:

  With ActiveSheet.Range("O2:O" & Cells(Rows.Count, 2).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
    .Formula = "formulahere"
  End With

It would also be helpful if you put the formula you have in the cell to test it in the macro.

But try it, if you have questions, don't hesitate to ask me.

Dante Amor

That worked!