multiple string dates in cell, to array, and manipulate single elements

[willara23]

Excel 2003 SP3

We use excel to record detail about rehabilitation cases. Related to TI (Totally Incapacitated) a client (record) can have more than one instance for TI.

The start and end dates are entered into a single cell with ALT+Enter to get a new line in cell.

Start date End date
14/09/2011 14/12/2011
06/12/2011 09/12/2011
09/02/2012 10/02/2012
29/02/2012 27/03/2012
20/06/2012 20/06/2012

I have a working solution in the attachment, which works reliably well.

At the time I had to use SPLIT to capture the cell string with Chr(10) and loaded to a variant variable, and then pushed the first variant variable contents into a second variant variable. I was then able to manipulate subsets of the original string to meet my need.

My question; is there a more succinct method to achieve the same result?

Please Login or Register  to view this content.

PS: the code is for all who find it useful.