selection range

[BorisS]

Have the following:
Range(Selection, Selection.End(xlDown) - 1).Select
Selection.FillDown
Selection.End(xlDown).Select

This is selecting everything to the next value in a list (I then filldown).
Need it to go to the value and then subtract 1 row from the range (so the
filldown does not overwrite the next value in the list).

Thanks.

--
Boris

[Dave Peterson]

Maybe...

Range(Selection, Selection.End(xlDown).offset(-1)).Select



BorisS wrote:
>
> Have the following:
> Range(Selection, Selection.End(xlDown) - 1).Select
> Selection.FillDown
> Selection.End(xlDown).Select
>
> This is selecting everything to the next value in a list (I then filldown).
> Need it to go to the value and then subtract 1 row from the range (so the
> filldown does not overwrite the next value in the list).
>
> Thanks.
>
> --
> Boris

--

Dave Peterson

[BorisS]

perfect. thanks.
--
Boris


"Dave Peterson" wrote:

> Maybe...
>
> Range(Selection, Selection.End(xlDown).offset(-1)).Select
>
>
>
> BorisS wrote:
> >
> > Have the following:
> > Range(Selection, Selection.End(xlDown) - 1).Select
> > Selection.FillDown
> > Selection.End(xlDown).Select
> >
> > This is selecting everything to the next value in a list (I then filldown).
> > Need it to go to the value and then subtract 1 row from the range (so the
> > filldown does not overwrite the next value in the list).
> >
> > Thanks.
> >
> > --
> > Boris
>
> --
>
> Dave Peterson
>