ADD Text to Cell Value // FILTERED Selection

[NEW_2VBA]

Hello! I'm sure this is an easy fix but I can't figure out how to change the code below to apply to visible cells only if user has selected cells within a filtered list.
It currently works however it updates all cells within a selected range, even cells not visible in a filtered list.

? I tried a few things (like adding SpecialCells(xlCellTypeVisible).Value) but it backfired & updated every cell in my workbook (luckily it was a test workbook) lol!


Dim c As Range
For Each c In Selection
If c.Value <> "" Then c.Value = "T&M to support unit costs: " & c.Value
Next

Thank you for your insight! ?

 

[Fluff]

Try

 For Each c In Selection.SpecialCells(xlVisible)

 

[NEW_2VBA]

Thanks so much! It worked! ?

 

[Fluff]

You're welcome & thanks for the feedback.