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