From: Gary''s Student on
I am given a range which is part of a single column, say D31:D257
I need an easy way to clip off the top cell, leaving D32:D257

Thanks in Advance
--
Gary''s Student - gsnu200908
From: Rick Rothstein on
There is always this way...

Set R = Range("D31:D257")
Set R = R.Offset(1).Resize(R.Rows.Count-1)

--
Rick (MVP - Excel)


"Gary''s Student" <GarysStudent(a)discussions.microsoft.com> wrote in message
news:EA56C9B1-0DE5-4203-A50E-2DE3EF79E51A(a)microsoft.com...
>I am given a range which is part of a single column, say D31:D257
> I need an easy way to clip off the top cell, leaving D32:D257
>
> Thanks in Advance
> --
> Gary''s Student - gsnu200908

From: Rick Rothstein on
Here is another method for you to choose from (which I kind of like for its
brevity)...

Set R = Range("D31:D257")
Set R = Range(R(2), R(R.Count))

--
Rick (MVP - Excel)


"Rick Rothstein" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote in message
news:uChQlYuYKHA.4012(a)TK2MSFTNGP04.phx.gbl...
> There is always this way...
>
> Set R = Range("D31:D257")
> Set R = R.Offset(1).Resize(R.Rows.Count-1)
>
> --
> Rick (MVP - Excel)
>
>
> "Gary''s Student" <GarysStudent(a)discussions.microsoft.com> wrote in
> message news:EA56C9B1-0DE5-4203-A50E-2DE3EF79E51A(a)microsoft.com...
>>I am given a range which is part of a single column, say D31:D257
>> I need an easy way to clip off the top cell, leaving D32:D257
>>
>> Thanks in Advance
>> --
>> Gary''s Student - gsnu200908
>

From: John_John on
Hi!
One way is below:

With rngCur
Set rngCur = .Rows(2 & ":" & .Cells.Count)
End With

...but is not the only one!

Ο χρήστης "Gary''s Student" έγγραψε:

> I am given a range which is part of a single column, say D31:D257
> I need an easy way to clip off the top cell, leaving D32:D257
>
> Thanks in Advance
> --
> Gary''s Student - gsnu200908
From: Gary''s Student on
Thanks!
--
Gary''s Student - gsnu200908


"John_John" wrote:

> Hi!
> One way is below:
>
> With rngCur
> Set rngCur = .Rows(2 & ":" & .Cells.Count)
> End With
>
> ..but is not the only one!
>
> Ο χρήστης "Gary''s Student" έγγραψε:
>
> > I am given a range which is part of a single column, say D31:D257
> > I need an easy way to clip off the top cell, leaving D32:D257
> >
> > Thanks in Advance
> > --
> > Gary''s Student - gsnu200908