Hello,
I am trying to add a comment to a filtered range in column B and I get an object doesn’t support error.
This is the filter and works correctly
I tired using this to add the comment
This worked for the first visible cell so thought I was close but stuck
Any help appreciated
I am trying to add a comment to a filtered range in column B and I get an object doesn’t support error.
This is the filter and works correctly
VBA Code:
Worksheets("feb").Range("A2").AutoFilter Field:=2, Criteria1:=Array("3216", "3227", "3256", "3290"), Operator:=xlFilterValues
I tired using this to add the comment
VBA Code:
Worksheets("Feb").AutoFilter.Range.Columns(2).Offset(1, 0).Resize(Rng.Rows.Count - 1, 1).SpecialCells(xlCellTypeVisible).AddComment "HI"
This worked for the first visible cell so thought I was close but stuck
VBA Code:
With Worksheets("Feb").Range("B2:B" & Cells(Rows.Count, 2).End(xlUp).Row).SpecialCells(xlCellTypeVisible)
.Cells.NoteText "Hi"
End With
Any help appreciated