Monday, February 29, 2016

Useful VBA code to switch between tabs on the ribbon in MS Word and Excel !!!

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 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.