I'm confused. See below.

[Zac]

I've tried several of peoples suggestion over the last few days and I'm stumped.

Here's my situation:

I have used the Data filter, which leaves "visible", Row #1 (which has all my header info), and rows (40:60).
(2:39) is hidden.
(61:300) is hidden.
Col "A" is void of data, my cell pointer is sitting at R1C2 ("B1").

This is all from within a macro.

What coding can I use that will drop me down 1 line to B40 (for this month it may be 40, next month it may be 50)?

NOTE (Very Important);
My goal is to have "anyone: use this macro from month to month.
But on this particular D/F sort, the visible rows will change each month. So I can't just GOTO B2 then drop down one row. Only because
the macro remembers only to goto (40,0).

Next month rows 26:80 might be visible, or
rows 50:150.

Hope you understand my dilemma.
I just wwant to go to the next visible line with data under B1.

Zac

[Damon Ostrander]

Hi Zac,

Then statement

SendKeys "{DOWN}"

will do the same thing as a down arrow key, which selects the next visible cell down. If you want a method that doesn't require selecting a cell at the beginning, the following macro selects the next visible cell below B1. This is a bit more robust in that it does not require that cell B1 be selected at the start, and does not depend on the sheet being active and in the active window when the macro runs.

Sub FirstVisibleCell()
'Selects the first visible cell in column B after row 1
Dim iRow As Long
With ActiveSheet.UsedRange
For iRow = 2 To .Row + .Rows.Count + 1
If Not Rows(iRow).Hidden Then
Cells(iRow, 2).Select
Exit Sub
End If
Next iRow
End With
End Sub