=index(a1:a100,n)
in code:

dim myVal as variant
dim n as long
n = 66
myval = application.index(worksheets("Somesheetname").rang e("a1:a100"), n)



MLT wrote:

Great! Now how about this: I have a user-defined one-dimensional
range (say A1:A100). How do I ask for the value of the nth element in
that range?

--

Dave Peterson