Nested Ranges?
Thanks Jim, that is an excelent description, and examples of nesting
ranges :)
Jim Thomlinson wrote:
Range takes two arguments. The second one is optional. The range is made up
of the rectangle where each cell is one of the corners... For example
Range(Range("A1"), Range("D5"))
is the same as
Range("A1:D5")
So for your problem...
Range(Range("BINFilStart").Offset(0, 1), Range("colBend")).Select
--
HTH...
Jim Thomlinson
" wrote:
Is it possible to a range within a range? For example to select a range
made up of two names I use the following:
Range("BINFilStart:colBend").Offset(0, 1).Select
However, BINFilStart should be offset and colBend should not. To meet
that need Ive tried a few things along the lines of:
Range("range(""BINFilStart"".Offset(0, 1)):colBend").Select
Nothing has worked and in this case I get runtime error 1004 Method
'Range' of object '_Global' failed. So far I can't find
anything in my references on nesting ranges.
Maybe I need a new approach?
|