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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Excel 2003 - Autofilter for protected cells 1
Autofilter misses last line 7
Excel Macro to use cells as a autofilter 0
HELP: Selecting Non-Visible (Hidden) Cells with AutoFilter Applied 3
Placement of autofilter drop down menu? 6
Autofilter 10
autofilter linked in different worksheets 2
Possible Autofilter Bug (2003 and 2007) 5

Back
Top