Oh, and when you say "values"... do you mean numbers or text? If text, will
there ever be spaces in the text? I ask this because if the answer is either
"numbers" or "text without spaces", then I think there is a more efficient
way to get to the values than looping through the cells.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Where did you want these values returned to... a VB array, a range, a
comma delimited string, somewhere else?

--
Rick (MVP - Excel)


"Gsurfdude" wrote in message
...
Hello,

I am fairly new to Excel VBA and I need to know how to loop through used
rows in a one column. In logic

for each row in column A starting @ A4 to A whatever

So I need to return values in A4-A whatever is used. I hope that makes
sense

Thanks!