Filter First Record
 

Hi,

I am new to Excel programming, I use Access mainly. I woudl like to run an
Excel macro from Access that goes to the first record in a filter that is
already applied. I think some of the code I need is this:

Selection.AutoFilter Field:=1, Criteria1:="[First Record??]", Operator:=xl

Cananyone help amend this so it filters on the first record?

Many thanks for your help.

Martin