- #1
- 68,057
- 21,599
I just wanted to check to see if this is a known problem, or if my issue is more likely related to something different.
I have an Excel spreadsheet that has a number of lines with comments and other information at the top, and then a matrix of cells below that on several rows. I had some Excel macros working to exchange information between the cells in those rows, but after deleting a couple extra comment lines above those rows, the macros are doing some nutzoid things in terms of moving cells.
I expected that the macro cell references would have been adjusted just like normal Excel cell references are when you delete rows or columns, but so far it looks like that did not happen. This problem may have been caused by a strange laptop crash/OS update around the same time, so that's why I'm asking if Excel macros have a known issue. Figuring that out will help me to do a better job of going back to my last known good check-in of my file.
Thanks!
I have an Excel spreadsheet that has a number of lines with comments and other information at the top, and then a matrix of cells below that on several rows. I had some Excel macros working to exchange information between the cells in those rows, but after deleting a couple extra comment lines above those rows, the macros are doing some nutzoid things in terms of moving cells.
I expected that the macro cell references would have been adjusted just like normal Excel cell references are when you delete rows or columns, but so far it looks like that did not happen. This problem may have been caused by a strange laptop crash/OS update around the same time, so that's why I'm asking if Excel macros have a known issue. Figuring that out will help me to do a better job of going back to my last known good check-in of my file.
Thanks!