Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inputing data into dynamic arrays
This seems like a really simple thing but I can't seem to figure it out
I need a function that will read data that a user inputs in an exce worksheet and store it into an array. The amount of data the use inputs varies from day to day. So for example, a user will inpu order numbers in column A starting in row 1 and going down the column. One day there may be a list of 10 order numbers, another day there ma be 20 order numbers and so on. How do I write a function that wil read those inputs and store them into an array -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
inputing data into dynamic arrays
Margie,
You sat arrays, but talk of rows, so I assume that you mean worksheets. cLastRow = Cells(Rows.Count,"A").End(xlUp).Row Cells(cLastRow+1,"A").Value = "whatever" -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "margie " wrote in message ... This seems like a really simple thing but I can't seem to figure it out. I need a function that will read data that a user inputs in an excel worksheet and store it into an array. The amount of data the user inputs varies from day to day. So for example, a user will input order numbers in column A starting in row 1 and going down the column. One day there may be a list of 10 order numbers, another day there may be 20 order numbers and so on. How do I write a function that will read those inputs and store them into an array? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
inputing data into dynamic arrays
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 a 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 store in the array until it's put into the worksheet. How do I write this i VB so that it stores the values in an array -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
inputing data into dynamic arrays
Dim rng As Range, arr() As Variant
Set rng = Range("A1").Resize(Application.CountA(Range("A1:A6 5336"))) 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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Arrays | Excel Discussion (Misc queries) | |||
Dynamic Range and arrays | Excel Discussion (Misc queries) | |||
Dynamic arrays | New Users to Excel | |||
Dynamic Arrays | Excel Worksheet Functions | |||
dynamic arrays in excel | Excel Programming |