View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Childs[_8_] Tim Childs[_8_] is offline
external usenet poster
 
Posts: 1
Default Code Snippet - Data Filter

Hi

If there is a worksheet with a table of data and other data beneath that, is
there a property associated with the Data Filter method that will return the
last row included in the filtered data i.e. the last row in scope of the
filtering, so it is not dependent on the current criteria set, just on the
basis of where the filter is including as being in scope. For the avoidance
of doubt, it is the last row the user included when the filter area was
created initially.

Many thanks

Tim