I need to 1. determine the last row of a column (This row varies each month.)
2. select a cell using this last row number.

I have written the following which solves number 1. above:
Range("B3").End(xlDown).Select
ActiveCell.Offset(1, 0).Select
ActiveCell.FormulaR1C1 = "X"
Columns("B:B").Select
ActiveWorkbook.Names.Add Name:="Decide", RefersToR1C1:="=Sheet1!C2"
Range("Z1").Select
Selection.NumberFormat = "General"
ActiveCell.FormulaR1C1 = "=Match(""X"",Decide,0)"

but when I try to reference the cell Z1 as the row number, I get a syntax
error.
How do I select a cell in column T and the last row number found as the
value in cell Z1?