if I have an excel named range. Lets say my_range. and it is the range of
$B$11:$B$51
How can I get the value of the first item?
lets say
B11 = AAA
B12 = BBB
etc....

=INDEX(my_range,1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"greg" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> if I have an excel named range. Lets say my_range. and it is the range
> of
> $B$11:$B$51
> How can I get the value of the first item?
> lets say
> B11 = AAA
> B12 = BBB
> etc....
>
>

thanks,
but not from a cell. but inside of vba


"Bob Phillips" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =INDEX(my_range,1)
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my
addy)
>
> "greg" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > if I have an excel named range. Lets say my_range. and it is the range
> > of
> > $B$11:$B$51
> > How can I get the value of the first item?
> > lets say
> > B11 = AAA
> > B12 = BBB
> > etc....
> >
> >
>
>

msgbox worksheets("Sheet999").range("my_Range").cells(1).value



greg wrote:
>
> if I have an excel named range. Lets say my_range. and it is the range of
> $B$11:$B$51
> How can I get the value of the first item?
> lets say
> B11 = AAA
> B12 = BBB
> etc....

--

Dave Peterson

I see this:
Dim rng As Range
Set rng = Worksheets("Sheet1").Range("my_range")
then rng has lots of things:
Value2
formula
but it does not seem like i can use them.
any help?




"greg" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> if I have an excel named range. Lets say my_range. and it is the range
of
> $B$11:$B$51
> How can I get the value of the first item?
> lets say
> B11 = AAA
> B12 = BBB
> etc....
>
>

Range("my_range").Cells(1,1)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"greg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> thanks,
> but not from a cell. but inside of vba
>
>
> "Bob Phillips" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> =INDEX(my_range,1)
>>
>> --
>> HTH
>>
>> Bob
>>
>> (there's no email, no snail mail, but somewhere should be gmail in my
> addy)
>>
>> "greg" <(E-Mail Removed)> wrote in message
>> news:%(E-Mail Removed)...
>> > if I have an excel named range. Lets say my_range. and it is the
>> > range
>> > of
>> > $B$11:$B$51
>> > How can I get the value of the first item?
>> > lets say
>> > B11 = AAA
>> > B12 = BBB
>> > etc....
>> >
>> >
>>
>>
>
>

Or slightly more efficiently

msgbox Worksheets("Sheet999").Range("my_Range")(1).value

Alan Beban

Dave Peterson wrote:
> msgbox worksheets("Sheet999").range("my_Range").cells(1).value
>
>
>
> greg wrote:
>> if I have an excel named range. Lets say my_range. and it is the range of
>> $B$11:$B$51
>> How can I get the value of the first item?
>> lets say
>> B11 = AAA
>> B12 = BBB
>> etc....
>

Bob Phillips wrote:
> Range("my_range").Cells(1,1)
>
Slightly more efficiently

Range("my_range")(1,1)

or, for the vertical range proposed

Range("my_range")(1)

Alan Beban

don't know what's more efficient, but just another way

Range("my_range").Range("A1")
--


Gary


"Alan Beban" <unavailable> wrote in message
news:%(E-Mail Removed)...
> Bob Phillips wrote:
>> Range("my_range").Cells(1,1)
>>
> Slightly more efficiently
>
> Range("my_range")(1,1)
>
> or, for the vertical range proposed
>
> Range("my_range")(1)
>
> Alan Beban

Yeah, but ugly, ugly, and not worth any performance gain, so I will not be
using it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Alan Beban" <unavailable> wrote in message
news:%(E-Mail Removed)...
> Bob Phillips wrote:
>> Range("my_range").Cells(1,1)
>>
> Slightly more efficiently
>
> Range("my_range")(1,1)
>
> or, for the vertical range proposed
>
> Range("my_range")(1)
>
> Alan Beban