Hi,

Im having problems with the following activity.
I want to filter a column and then fill another column (only with header) with ("Yes") all the way down.

For doing that, I would like to count how many rows are in the visible column, to estimate the last visible row.

Once I got that, I would like that my code will work:

LastRow=Range ("D" & Rows.Count).End(xlUp).Row -1 (headers)

Range("E2:E & LastRow").SpecialCells(xlCellsTypeVisible).Value = "Yes"

Could you please help me with that?

Thanks in advance