Currently my code has these initial components
I am trying to use this line but I am getting an error
I am unsure if I am referencing the Range incorrectly or if there is something wrong with my formula
If I want the cells referenced within COUNTIF to change according to column should I ".Select" the intended Range and then use "FillDown"?
Thanks for the help in advance!
VBA Code:
Dim r As Long
Dim lr As Long
Dim lc As Long
lr = Cells(Rows.Count, "A").End(xlUp).Row
lc = Cells(1, Columns.Count).End(xlToLeft).Column
r = lr
I am trying to use this line but I am getting an error
VBA Code:
Range(Cells(r, "C"), Cells(r, lc)).Formula = "=IF(COUNTIF(C4:C5,"X"),"X","")"
If I want the cells referenced within COUNTIF to change according to column should I ".Select" the intended Range and then use "FillDown"?
Thanks for the help in advance!