Cannot hide columns (EXCEL 97/2000)

[ErikJan]

Have this code:

[Range_hor].EntireColumn.Hidden = False
'
For Each c In [Range_hor]
If c.Value = "xxx" Then c.EntireColumn.Hidden = True
Next

(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???

Erik Jan

[pieterse]

I seem te recall this having something to do with the properties of the comment: Whether or not they are set to Move and size with cells. Open a comment, rightclick its border and choose format comment. Then find the tab that has this option. Try the variations there...

[sdckapr]

This might help. It discusses this eror message:
http://support.microsoft.com/default.aspx?...kb;en-us;170081

Steve

[ErikJan]

Believe that did the trick! It's solved now, thanks (again!)!!

EJ