| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select the 2nd cell from the top in the column with filter
Hi all, i want the select with code the 2nd cell from the top in the column A
which has filtered data so i don't know which line it is (it could be any depending on the filter settings) and i want to know the position of that cell when i hit the commandbutton on that sheet. Thanks for help. PS: Application.sendkeys"^{home}" didn't help Henrich |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select the 2nd cell from the top in the column with filter
Try this loop.
Sub FindNextVisible() Dim cnt As Long Dim Filtered As Boolean Filtered = False cnt = 1 Do Filtered = Rows(Range("A1").Offset(cnt, 0).Row).Hidden cnt = cnt + 1 Loop While Filtered MsgBox "A" & cnt End Sub Charles Chickering Henrich wrote: Hi all, i want the select with code the 2nd cell from the top in the column A which has filtered data so i don't know which line it is (it could be any depending on the filter settings) and i want to know the position of that cell when i hit the commandbutton on that sheet. Thanks for help. PS: Application.sendkeys"^{home}" didn't help Henrich |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select the 2nd cell from the top in the column with filter
Charles,
thanks many time, it's working PERFEKT!!! Henrich €žDie_Another_Day" napĂ*sal (napĂ*sala): Try this loop. Sub FindNextVisible() Dim cnt As Long Dim Filtered As Boolean Filtered = False cnt = 1 Do Filtered = Rows(Range("A1").Offset(cnt, 0).Row).Hidden cnt = cnt + 1 Loop While Filtered MsgBox "A" & cnt End Sub Charles Chickering Henrich wrote: Hi all, i want the select with code the 2nd cell from the top in the column A which has filtered data so i don't know which line it is (it could be any depending on the filter settings) and i want to know the position of that cell when i hit the commandbutton on that sheet. Thanks for help. PS: Application.sendkeys"^{home}" didn't help Henrich |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
| select every other cell in a column | Excel Discussion (Misc queries) | |||
| Select specific column for auto filter | Excel Worksheet Functions | |||
| How do I select last cell in column plus 1? | Excel Programming | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Linear Mode
