Prev: Selecting items from list and attaching ratios to selection
Next: Split cells VBA
From: Rick Rothstein on 3 Mar 2010 10:51
Where did you want these values returned to... a VB array, a range, a comma
delimited string, somewhere else?

--
Rick (MVP - Excel)


"Gsurfdude" <Gsurfdude(a)discussions.microsoft.com> wrote in message
news:9F6A0431-318E-4B02-BD01-E09C8EF40091(a)microsoft.com...
> 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!

From: Rick Rothstein on 3 Mar 2010 11:13
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" <rick.newsNO.SPAM(a)NO.SPAMverizon.net> wrote in message
news:%235TxcluuKHA.732(a)TK2MSFTNGP06.phx.gbl...
> Where did you want these values returned to... a VB array, a range, a
> comma delimited string, somewhere else?
>
> --
> Rick (MVP - Excel)
>
>
> "Gsurfdude" <Gsurfdude(a)discussions.microsoft.com> wrote in message
> news:9F6A0431-318E-4B02-BD01-E09C8EF40091(a)microsoft.com...
>> 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!
>

First  |  Prev  | 
Pages: 1 2
Prev: Selecting items from list and attaching ratios to selection
Next: Split cells VBA