View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pete the greek pete the greek is offline
external usenet poster
 
Posts: 17
Default how do i identify first and last row once filter applied

having applied an auto filter in vba how do i indentify the first and last
row of the result also is it possible to read the number of rows. i assume
this is held somewhere as it is used in the status bar message