Select First Cell In Filtered Table

[BenGee]

Hi

This code literally returns the first value of my table regardless to whether a filter is applied and the row hidden;

        Worksheets("C&I Calculator").Range("C14").Value = Worksheets("Live Deals").Range("N5", Cells(Rows.Count, "N").End(xlUp)).Cells(2, 1)

But I want it to return the 1st value of a filtered table i.e. After filtering, the very first value still showing.

If it helps, after filtering the table, there will only ever be 1 value showing.

Thanks in advance

 

[mumps]

Doe this work for you?

Worksheets("C&I Calculator").Range("C14").Value = Worksheets("Live Deals").Range("N5", Worksheets("Live Deals").Cells(Worksheets("Live Deals").Rows.Count, "N").End(xlUp)).SpecialCells(xlCellTypeVisible).Cells(1, 1)

 

[Fluff]

Similar & assumes that your header is in row 4

Worksheets("C&I Calculator").Range("C14").Value = Worksheets("Live Deals").Range("N5:N" & Rows.Count).SpecialCells(xlVisible)(1).Value

 

[BenGee]

This worked a treat, thank you Fluff

 

[Fluff]

You're welcome & thanks for the feedback