newbie range question
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
--
HTH...
Jim Thomlinson
" wrote:
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
|