Range Selection

Well, If I had to use the row and column indexes, I don't have to use the
cells option at all and I can simply put it as A1:A17

OK, what I.m trying to do is to search for a name in a list (Row 1to 100 and
column 3) and copy the information against that name.
I've put in a loop to search the name in the 100 rows.


Baapi


"Nick Hebb" wrote:

> >>Range("Cells(R1, C1 + 2):Cells(R1, C1 + 16)").Copy
>
> Get rid of the quotes and use the row and column indexes in instead of
> the R1, C1 references:
>
> Range(Cells(1, 3):Cells(1, 17)).Copy
>
> Nick Hebb
> BreezeTree Software
> http://www.breezetree.com
>
>

i am trying to picture your sheet. you have names in column c in rows 1 to
100. where's the data you want to copy located?

--


Gary


"Baapi" <Baapi@discussions.microsoft.com> wrote in message
news:4CCB4D5A-3712-4CFB-9C1B-878D98A152D3@microsoft.com...
> Well, If I had to use the row and column indexes, I don't have to use the
> cells option at all and I can simply put it as A1:A17
>
> OK, what I.m trying to do is to search for a name in a list (Row 1to 100
> and
> column 3) and copy the information against that name.
> I've put in a loop to search the name in the 100 rows.
>
>
> Baapi
>
>
> "Nick Hebb" wrote:
>
>> >>Range("Cells(R1, C1 + 2):Cells(R1, C1 + 16)").Copy
>>
>> Get rid of the quotes and use the row and column indexes in instead of
>> the R1, C1 references:
>>
>> Range(Cells(1, 3):Cells(1, 17)).Copy
>>
>> Nick Hebb
>> BreezeTree Software
>> http://www.breezetree.com
>>
>>