Range(Selection, Selection.End(xlToRight).Offset(0, 2)).Select

"davegb" wrote:

> This code gives me an invalid qualifier error:
>
> Range("B4").Select
>
> Range(Selection, Selection.End(xlDown)).Select
> Range(Selection, Selection.End(xlToRight.Offset(0, 2))).Select
>
> I want to select a range starting at B4, ending at the bottom of column
> B, going to the right until the data ends, and then adding 2 more
> columns to the range. Can someone point me in the right direction?
> Thanks!
>
>