Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter & Selecting First Visible Cell
Hi,
I have an AutoFilter which will display one row of data (one visible row), I want to be able to grab the value from the 5th column in that one visible row. How can I do this? Thanks. Simon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter & Selecting First Visible Cell
Here is one way. The below macro assumes you have header in Row 1
Sub Macro() Dim lngRow As Long lngRow = 1 Do lngRow = lngRow + 1 Loop Until Rows(lngRow).Hidden = False MsgBox Cells(lngRow, 5) End Sub If this post helps click Yes --------------- Jacob Skaria "Simon" wrote: Hi, I have an AutoFilter which will display one row of data (one visible row), I want to be able to grab the value from the 5th column in that one visible row. How can I do this? Thanks. Simon |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter & Selecting First Visible Cell
you can use the worksheet function subtotal this will allow you to capture
the visible row something like '=SUBTOTAL(109,E2:E1000)' Please post back if this was helpful "Simon" wrote in message ... Hi, I have an AutoFilter which will display one row of data (one visible row), I want to be able to grab the value from the 5th column in that one visible row. How can I do this? Thanks. Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied | Excel Discussion (Misc queries) | |||
HELP: Selecting Non-Visible (Hidden) Cells when AutoFilter is Appl | Excel Worksheet Functions | |||
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied | Excel Discussion (Misc queries) | |||
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied | Excel Discussion (Misc queries) | |||
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied | Excel Discussion (Misc queries) |