Re: $$Excel-Macros$$ Define a Range based on a Range object

2010-10-15 Thread siti Vi
Set xRange = Range("C1:D10") xRow = 5 Set yRange = xRange.Offset(xRow-1, 0).Resize(xRow+1, xRange.Columns.Count) CMIIW On Fri, Oct 15, 2010 at 4:06 AM, TerryP wrote: > > Given a Range object (e.g: set xRange = Range("C1:D10") ) > And given xRow = 5 , which stands for Row 5 (absolute Row inde

$$Excel-Macros$$ Define a Range based on a Range object

2010-10-14 Thread TerryP
Given a Range object (e.g: set xRange = Range("C1:D10") ) And given xRow = 5 , which stands for Row 5 (absolute Row index) How to define a range "yRange" based on "xRange" so that yRange is Range("C5:D10") ? thanks -- -