limit Row Selection

[Av8tordude]

I have this code that selects the first visible row. If only 1 visible row is displayed, for some reason its selects row one. How can ensure it does not select any rows above row 7?

Range("A7", Cells(Rows.Count, "A").End(xlUp)).SpecialCells(xlCellTypeVisible).Cells(1, 1).Select

 

[Fluff]

If A7 is the last visible row, that code will look at the entire sheet.
You should calculate the last row of data before filtering & then use that rather than Cells(Rows.Count, "A").End(xlUp)

 

[Av8tordude]

I have 3 unique entries currently (note: only for testing purpose); (SPY, AAPL, AMZN) .
When I filter for the first entry (SPY), it will go to A1 instead of A7. However, if (SPY) has more than 1 entry, then it would go to A7.

 

[Fluff]

Is A7 the header row?

 

[Av8tordude]

Is A7 the header row?

No...a6 is the header

 

[Fluff]

In that case you will need to do what I suggested.

 

[Av8tordude]

Thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback.