Asterix
01-25-2008, 02:58 AM
Why doesn't the 3rd line work?
time_difference_text = Worksheets("Overall standings").Range(lowest_score_address).Comment.Text
comment_to_be_added = "Dropped score = " & Cells(i, lowest_score_column).Value & " / Time difference = " & time_difference_text
Worksheets("Overall standings").Range(lowest_score_address).AddComment = comment_to_be_added
time_difference_text = Worksheets("Overall standings").Range(lowest_score_address).Comment.Text
comment_to_be_added = "Dropped score = " & Cells(i, lowest_score_column).Value & " / Time difference = " & time_difference_text
Worksheets("Overall standings").Range(lowest_score_address).AddComment = comment_to_be_added