Beginner Array / RefEdit Assistance
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!
Re: Beginner Array / RefEdit Assistance
What code have you got and where are you reading from...?