newbie range question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scott.siegler@gmail.com - 28 Feb 2006 20:24 GMT

Hello,

I am new to vba and want to write a function that takes a range of
cells as the argument. In VBA I want to be able to mostly access the
value in the first cell, and the value in the last cell. Do I want to
use the 'range' type for this? By playing around, it seems ".value"
gives me the value in the first cell. Is there a way to get the value
in the last cell of the range?

thanks for any help,
scott

Reply to this Message

Jim Thomlinson - 28 Feb 2006 22:30 GMT

A range object should work for you. What you need is to access the item to
select the appropraite cells, something like this...

dim rng as Range

set rng = Sheets("Sheet1").Range("A1:C10")

with rng
msgbox .value 'This one you know about
msgbox .item(.count).value 'The last item in the range
end with

Signature

HTH...

Jim Thomlinson

> Hello,
>
[quoted text clipped - 7 lines]
> thanks for any help,
> scott

Reply to this Message