Redefine a Range
in [Programming]
|
Prev: Run Code in Another Workbook
Next: Macro to populate cell value from another sheet based upon the data validation list selection
From: Gary''s Student on 11 Nov 2009 10:28 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 11 Nov 2009 10:46 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 11 Nov 2009 10:56 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 11 Nov 2009 10:58 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 11 Nov 2009 13:48
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 |