BobTheBuilde
07-18-2008, 03:16 PM
Hey guys,
For further reference I'm using Excel 2003 - I think memory might be an issue here.
I'm developing a spreadsheet that does a whole lot of deleting and re-making objects.
My question is that, at some point I end up getting a run-time error (1004) when trying to do something similar to the following (creating any object):
ActiveSheet.CheckBoxes.Add(ActiveCell.Left - 1, ActiveCell.Top + 21, 11, ActiveCell.Height * 0.25).Select
This error occurs for ALL objects, not just checkboxes. I have recently found out, however, that this only happens to one of my sheets (one that does most of the deletining-and-then-recreating object). Furtermore, you'll be interest to hear that the number in the objects text are just above 65536 (the maximum number of rows allowed in a cell!).
For example:
If I were to create a checkbox it would be checkbox65537 (or something like that)
If I were to creat a commandbutton it would be commandbutton65537 (or something like that)
I'm thinkin' all I need to do is tell excel to take some stuff out to the garbage but I can't figure it out! Does anyone know how to fix this?
Thanks in advance: pray2:
For further reference I'm using Excel 2003 - I think memory might be an issue here.
I'm developing a spreadsheet that does a whole lot of deleting and re-making objects.
My question is that, at some point I end up getting a run-time error (1004) when trying to do something similar to the following (creating any object):
ActiveSheet.CheckBoxes.Add(ActiveCell.Left - 1, ActiveCell.Top + 21, 11, ActiveCell.Height * 0.25).Select
This error occurs for ALL objects, not just checkboxes. I have recently found out, however, that this only happens to one of my sheets (one that does most of the deletining-and-then-recreating object). Furtermore, you'll be interest to hear that the number in the objects text are just above 65536 (the maximum number of rows allowed in a cell!).
For example:
If I were to create a checkbox it would be checkbox65537 (or something like that)
If I were to creat a commandbutton it would be commandbutton65537 (or something like that)
I'm thinkin' all I need to do is tell excel to take some stuff out to the garbage but I can't figure it out! Does anyone know how to fix this?
Thanks in advance: pray2: