Hello,
I did a search and did not find anything on this subject. I am using the cell comments to record changes to data in that cell with a date and time stamp. If today I enter '25' in cell A1, vba code will add the the cell's comment 2014-11-10 4:48:00 PM {25}
If tomorrow I enter '82' in cell A1, vba code appends to the existing comment the new entry. The full comment will look as follows:
2014-11-10 4:48:00 PM {25}
2014-11-11 2:15:13 PM {82}
Data may change many times for cell A1 and thus its comment field may have many lines in it each representing data entered at a specific date and time. If the comment field has 10 lines of data, is there a way to search the comment and find data on the last two lines, or say identify the 5th line if necessary and retrieve its data? In particular I would be after the data in the curly brackets.
Thanks for any help.
TV
Bookmarks