I have a table with filters created using VBA with several comments. All comments are important and there is a huge amount of data on it. I am trying to find a way to avoid error messages when filters are applied. I know that if I loop trough a entire column and set
`Comment.Shape.Placement = xlMoveAndSize` by cells it should work, but is there a way to select the entire range like this?

```
masterSheet.Columns(columnExtension).Comment.Shape.Placement = xlMoveAndSize

```

I also tried in this context:

```
'Final formating -----------------------------------------------

masterSheet.Activate
masterSheet.Columns(columnExtension).Font.Size = 12
masterSheet.Columns(columnExtension).Font.Bold = True
masterSheet.Columns(columnExtension).NumberFormat = "0"
masterSheet.Columns(columnExtension).HorizontalAlignment = xlCenter

ActiveSheet.UsedRange.SpecialCells _
(xlCellTypeComments).Comment.Shape.Placement = xlMoveAndSize

masterSheet.Columns.AutoFit

```