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/