| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit on number of comments in a worksheet
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a limit to the number of formulas in an Excel worksheet? | Excel Worksheet Functions | |||
| How to limit number of rows and column in worksheet? | Excel Discussion (Misc queries) | |||
| is there a limit to the number of rows a worksheet can have? | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows displayed on a worksheet? | Excel Discussion (Misc queries) | |||
| How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions | |||
Threaded Mode
