Home Use a macro in a range reference
 bottom = Cells(Rows.Count, 1).End(xlUp).Row Range("A2").FormulaR1C1 = "=countblank('[Test.xlsx]Sheet1 test'!C1:C1)"  I am trying to use the "bottom" value in my range !C1:C1). I want to be able to count the value of missing cells in a column. I tried several combinations but I couldn't find a way of making it work. For example if bottom is 10, I want it to count the missing values in column 1 up to row 10.