Excel VBA Select First visible cell

preview_player
Показать описание
Select First Visible cell after an auto filter using Excel VBA
Рекомендации по теме
Комментарии
Автор

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

rreesse
Автор

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

Finded a faster code if helps. :)

vitorfurtadodemoura
Автор

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

YABEEful
Автор

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

omkarinamake
Автор

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

rakeshchowdary