Apologies as I am pretty sure this was asked before , but I couldn't find the correct thread. I am new to VBA so could be that I am not searching properly.

I have a worksheet that uses column A to DD. I have a task(outside of excel) that find the last used row in this worksheet and paste data daily, except for the last 2 columns. Last two rows have formula which is noted below. I am looking for a macro that can autofill the blank cells in each column with below formula. I prefer the macro to paste the formula only from blank cell down, rather than from cell CZ2 and CY2 onwards.

Column CZ formula is INDEX(Categories,MATCH(TRUE,ISNUMBER(SEARCH(Keywords,I2)),0))
Column CY formula is =IF(LEFT(S2,3)="rem","Ignorefromanalysis",W2)

There are no blank cells in Column A so i can use column A to find the total range for pasting formula Down.

Below is an example ) that could work, but it copies the formula from cell 2 -down, rather than from the first empty cell-down.
Cells(5,1).Select
Selection.End(xlDown).Select
lastRow = ActiveCell.Row
Range(Cells(2,3),Cells(lastRow,3)) = .....my formula

Thanks for the help.