I have a large selection of excel comments. I am trying to set a range of comments to xlMoveandSize. The problem is that excel is not letting set a range of cells, SpecialCells(xlCellTypeComments), properties all at once. The only way I can find to do this is by doing a 'for each loop.
That takes way too long!!
Any other suggestions how to set a range of cells comment property to be xlmoveandsize?
Obviously I am doing this through VBA.
I am relying on this board to help me out. Research has been unsuccessful to get the answer.
Thanks
That takes way too long!!
Any other suggestions how to set a range of cells comment property to be xlmoveandsize?
Obviously I am doing this through VBA.
I am relying on this board to help me out. Research has been unsuccessful to get the answer.
Thanks