I just posted a response to this same question over in the Microsoft forum
(I'm assuming you posted it there as the ranges look familiar).

--
Rick Rothstein (MVP - Excel)


"Terry" wrote in message
...

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") ?