seanpears99
New Member
- Joined
- Aug 22, 2006
- Messages
- 21
Hi
I have a column of months and years
January 2012
February 2012
March 2012
April 2012
May 2012
I ask the user to select a start date and end date and need to build an array of the start and end dates and the ones which fall in between, i.e. if they select February 2012 and May 2012, I need to load, February to May 2012 into an array for sheet selection processing.
I am not the most proficient of coders, this is a hobby, so currently I was looping (do while) down the list until I hit the start date and then looping from there to the end date and loading the array in between.
Is this best way to do this?
Thanks
Sean
I have a column of months and years
January 2012
February 2012
March 2012
April 2012
May 2012
I ask the user to select a start date and end date and need to build an array of the start and end dates and the ones which fall in between, i.e. if they select February 2012 and May 2012, I need to load, February to May 2012 into an array for sheet selection processing.
I am not the most proficient of coders, this is a hobby, so currently I was looping (do while) down the list until I hit the start date and then looping from there to the end date and loading the array in between.
Is this best way to do this?
Thanks
Sean