Beginner Array / RefEdit Assistance

[jcholak718]

Hi folks -

I've got a userform with a RefEdit box named 'schedule' with which the user will select a single column of cells (variable length). What I need to do with this range of cells is:

-read the values into an array for further processing
-count the number of non-blank values
-assure that the sum of the values adds up to 1.00 (percentages); error out if it does not
-loop through the array values and assign them to a specific variable

I know this is pretty much arrays 101 but all of my searches have turned up results that are far too advanced. All help is much appreciated.

Thanks!

[Ecniv]

What code have you got and where are you reading from...?