Excel VBA Select First visible cell

I want to write a value in one column for all filtered rows,, please tell if having any idea

what about second visible cell??

Simplest and most straightforward solution I have found in weeks. Love it. Thank you!

Thank you so much

ThisWorkbook.ActiveSheet.AutoFilter.Range.Offset(1).SpecialCells(xlCellTypeVisible).Cells(1, 1).Select

Finded a faster code if helps. :)

you are a lifesaver.. subscribed.. Thanks a lot.. !!

You are great 👍. Thanks

Hello...what if the there is no data after filtering? How it works?