Switch between various tab is one the very useful activity for certain VBA automation. Which is different for excel and word VBA programming. I got trick to navigate tabs on MS-Word or MS-Excel ribbon programmatically.
Monday, February 29, 2016
Monday, February 8, 2016
Most useful VBA code to delete unused items and refresh pivot table in activeworkbook
Pivot in excel is most useful functionality to aggregate and summarize huge data. It is one the most useful reporting tool in excel which used to represent meaningful data from a large data set. Many a times back end data get refreshed for these pivots. Which generates missing items in pivot table which not require anymore.
Removing missing items from various pivots sometime would be a quite time consuming task.
Removing missing items from various pivots sometime would be a quite time consuming task.
Subscribe to:
Posts (Atom)