Thread: Macro : seeking max value after an Autofilter
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
tinyjack tinyjack is offline
external usenet poster
  
Posts: 2
Default Macro : seeking max value after an Autofilter
You can use the SpecialCells method of the Range object
and use the xlCellTypeVisible type.

HTH

TJ
Reply With QuoteReply With Quote