title: To make comments move with cells in a filtered table on excel VBA
body: <p>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
  <code>Comment.Shape.Placement = xlMoveAndSize</code> by cells it should work, but is there a way to select the entire range like this?</p>
  
  <pre><code>masterSheet.Columns(columnExtension).Comment.Shape.Placement = xlMoveAndSize
  </code></pre>
  
  <p>I also tried in this context:</p>
  
  <pre><code>'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
  </code></pre>