Knockoutpie
Board Regular
- Joined
- Sep 10, 2018
- Messages
- 116
- Office Version
- 365
- Platform
- Windows
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.
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.