I've got the following to define a value on another worksheet and it works.

Sheets(Summary.Name).Cells(Sheets(Summary.Name).Ce lls(Rows.Count,
"A").End(xlUp).Row + 1, 1).Value = Target.Offset(0, 6 - Target.Column).Value

What I want to do is select a range including this cell up to 12 columns to
the right to put a border on it. I've tried this:

Sheets(Summary.Name).Cells(Sheets(Summary.Name).Ce lls(Rows.Count,
"A").End(xlUp).Row + 1, 12).Select

I get "Select method of range class failed"

Thanks