ExcelBanter - Finding comments

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Finding comments - help needed ! (https://www.excelbanter.com/excel-programming/275934-re-finding-comments-help-needed.html)

Alex T

Finding comments - help needed !

Tom,

Thanks for your message - nice suggestion !

As it turns out

locStr = aCell.NoteText

works wheras

locStr = aCell.Comment.Text fails.

Don't know why but problem solved !

--alexT

All times are GMT +1. The time now is 08:57 AM.