Working with simple multilined cells

[Gordon@work]

Hello,
I'm having a really tough time trying to do some string manipulation.

I realise that working with strings is generally quite straight forward, but I've tried to make this loop work properly for about three days and I'm just not getting anywhere.

Ultimately, the script simply needs to identify the specified line within a cell and insert new data on that line (the system date in this case.)

Ideally the routine would bail out if the particular line number does not exist in the cell, but I'll make it do that once I've got it inserting the new data into the correct place.

The code is as follows and I have attached the workbook:

Please Login or Register  to view this content.

Thanks for your consideration,

- Gordon

[rylo]

Gordon

Try

Please Login or Register  to view this content.

rylo

[Gordon@work]

Wow that's a beautiful function!

I have no idea how often I could have put it to good uses in the past, but I had no idea that it existed.

Thank You for the assistance and enlightenment rylo, this will be a function I'll be using almost every day now!

- Gordon