Referencing a cell to the 1st line of data when "AutoFilter" is on.

  • Thread starter Thread starter Glen
  • Start date Start date
G

Glen

Hello,

I have "AutoFilter" on and would like to reference a cell
to the first cell of data in column A i.e the reference
cell will change as you change your selected filter in
column A.

.........any suggestions?

Please let me know if the above query does not make any
sense.

Thanks

Glen
 
Back
Top