mae0429
06-10-2008, 02:32 PM
Hello ever-helpful VBA gurus,
I would like to know of a way I can check if a cell is hidden or not, and if it is not hidden, count it in a summation. Only problem is, I want this to be a real-time cell on the sheet, as it will reflect the number of items in a pivot table. That way, the user can look at the top of the sheet and know how many items fall under that specific drill-down of the pivot (counting by eye is out, as there are over 1000 entries and pivoting will take out random entries).
If any part of that is unclear, let me know.
Thanks and good luck!
-Matt
I would like to know of a way I can check if a cell is hidden or not, and if it is not hidden, count it in a summation. Only problem is, I want this to be a real-time cell on the sheet, as it will reflect the number of items in a pivot table. That way, the user can look at the top of the sheet and know how many items fall under that specific drill-down of the pivot (counting by eye is out, as there are over 1000 entries and pivoting will take out random entries).
If any part of that is unclear, let me know.
Thanks and good luck!
-Matt