Selecting range programmatically
 

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

Selecting range programmatically
 

Barb,

You need to activate a sheet before you can select a range. Try:

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


HTH,
Bernie
MS Excel MVP


"Barb Reinhardt" wrote in message
...
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