Ok Ok Ok let me rephrase the question
I need to know what the first visible item is in column A.
I can see it but I need xl to see it so that I may use the value.
In real life all I would do to achieve this is select a1 and use the down arrow or enter to reach the first visible record.
I think I have exhausted all the options associated with the filter so I am guessing I need to do this using select offset or some such.