Re: inputing data into dynamic arrays
From: Alan Beban (alannospambeban_at_pacbell.net)
Date: 02/26/04
- Next message: Ed: "Re: How do you test to break out of a find loop?"
- Previous message: alexm999: "Deleting rows"
- In reply to: margie: "Re: inputing data into dynamic arrays"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 15:11:41 -0800
Dim rng As Range, arr() As Variant
Set rng = Range("A1").Resize(Application.CountA(Range("A1:A65336")))
arr = rng.Value
Alan Beban
margie < wrote:
> Maybe I should try to clarify myself. Suppose a user inputs
> A
> 1 red
> 2 orange
> 3 yellow
> 4 green
> 5 blue
>
> (in a worksheet this is column A rows 1 through 5).
>
> Now I need a function that will read these inputs and store them in an
> array. But lets say tomorrow the user inputs 6 colors instead of 5.
> The array is dynamic so you don't know how many values will be stored
> in the array until it's put into the worksheet. How do I write this in
> VB so that it stores the values in an array.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
- Next message: Ed: "Re: How do you test to break out of a find loop?"
- Previous message: alexm999: "Deleting rows"
- In reply to: margie: "Re: inputing data into dynamic arrays"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
