Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get of all number rows in the autofilter range
Hello.
In the sheet i have autofilter And after appled autofilter I need get of all number rows in .AutoFilter.Range.SpecialCells(xlCellTypeVisible) Thank you for you time |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get of all number rows in the autofilter range
Valery,
Not quite sure what you are looking for.... try, maybe, this: Sub Macro1() Dim myA As Range Dim myC As Range Dim myR As Range Set myR = Intersect(Columns("B:B"), Range("B2").CurrentRegion) _ .SpecialCells(xlCellTypeVisible) For Each myA In myR.Areas For Each myC In myA.Cells MsgBox "Cells in row " & myC.Row & " are visible." Next myC Next myA End Sub HTH, Bernie MS Excel MVP "Valery" wrote in message ... Hello. In the sheet i have autofilter And after appled autofilter I need get of all number rows in .AutoFilter.Range.SpecialCells(xlCellTypeVisible) Thank you for you time |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA (or Excel) crashes if Count of Visible Rows in Autofilter Range = 1 | Excel Programming | |||
Deleting rows in a range using Autofilter | Excel Discussion (Misc queries) | |||
number of rows returned by autofilter? | Excel Programming | |||
How do I get the number of rows that meet an autofilter criterion. | Excel Worksheet Functions | |||
How can I make autofilter show the filtered number of rows | Excel Worksheet Functions |