Have this code:
[Range_hor].EntireColumn.Hidden = False
For Each c In [Range_hor]
If c.Value = "xxx" Then c.EntireColumn.Hidden = True
(The sheet has some cells with comments attached) This has always worked fine. Recently I added even more spare-columns (which are filled with "xxx" as placeholder). Now when I run the code (or try to delete a column manually) somewhere half way I get an error indicating: "Cannot shift object off sheet".
Normally I know why this happens: if e.g. there is no space anymore to display a comment to the right if one deletes all columns there. In this case I'm puzzled as to the right of my matrix: in columns FJ all the way to column IV there is nothing!! (I even re-deleted them all just to make sure)...
What's going on and how can I prevent?? Is there a max # of filled columns one can only delete???