Limit on number of comments in a worksheet

[dyowee]

Good day!
I've written a macro that validates the cell values in a worksheet, and
writes the error messages as comments in each cell. The problem I'm having is
that if there are too many rows (at least 2000) and too many errors, writing
all those comments make Excel slow and the memory usage very high (at least
200MB), and causes "Excel cannot complete this task with available
resources...". Why is this so? Is there any workaround for this?

Thank you very much.

 

[Gary''s Student]

Consider using an audit sheet. As your macro validates values on your data
sheet, have it record the row/column id of error records an the audit sheet.
It can even change the background color of cells on the data sheet to help
visually see where the problems are.

 

[dyowee]

What is an audit sheet? =)

Consider using an audit sheet. As your macro validates values on your data
sheet, have it record the row/column id of error records an the audit sheet.
It can even change the background color of cells on the data sheet to help
visually see where the problems are.