Re: Isolate a region
- From: "Harlan Grove" <hrlngrv@xxxxxxx>
- Date: Fri, 29 Apr 2005 22:10:11 -0700
"Bernie Deitrick" <deitbe @ consumer dot org> wrote...
>Just curious. Why use:
....
>instead of just:
>
> For n = 2 To Selection.Areas.Count
> Set r = Range(r, Selection.Areas(n))
> Next n
....
No good reason. Your loop is better. I didn't know .Range worked this way.
>And to rs: Harlan's code is written to account for future increases in
***
>size.
That too, but I did it because the OP asked to avoid hardcoding.
.
- References:
- Re: Isolate a region
- From: Harlan Grove
- Re: Isolate a region
- Prev by Date: Re: Vlookup
- Next by Date: Re: Import Spec for excel?
- Previous by thread: Re: Isolate a region
- Next by thread: Find MIN of Dates and Returns Value
- Index(es):
