View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_140_] John[_140_] is offline
external usenet poster
 
Posts: 57
Default Table properties/Table total Row problem

I would like the Worksheet_Change event to do one sub procedure if an
Excel 2007 table is filtered, and I would like it to do another subroutine
if it is not filtered. Is there a table property or some way of
determining this? Specifically, I'm trying to programmatically change my
Table Total Row formulas based on on whether my Table is filtered or not.