SUE' EXCEL WORLD
Saturday, June 23, 2012
Excel 2010 – Shown Developer tab in the Ribbon
›
Excel 2010 File->Option->Customize Ribbon->Click Developer on the Customize the Ribbon, Main Tabs List © Copyright Exce...
Excel File – Child Monthly Expense w Download file
›
This Child Monthly Expense spreadsheet is designed for parents to create a budget for the kid and track the actual expense. It i...
Excel 2010 – Sparkline
›
Recently, I updated Excel to 2010 version. I noticed that under “Insert Ribbon”, there is a new charting feature called SPARKINE. It allows ...
Friday, June 22, 2012
Excel VBA – Use SHELL function to open a folder
›
I try to make my administrative work fun. I got a project that I need group more than 40 files together in one big folder. Those 40 fil...
1 comment:
Tuesday, June 5, 2012
Excel VBA –ReDim Preserve
›
ReDim statement is used to resize a dynamic array. When ReDim Statement is used, all the values assigned prior to resize the array are era...
Excel VBA – Copy Filtered data using Autofilter in VBA into Array (2) - with no blank data
›
T he macro in the “Copy Filtered data using Autofilter in VBA into Array” transfers the filtered data using autofilter comment to an array. ...
Monday, June 4, 2012
Excel VBA – Remove the autofilter in Excel VBA
›
Auto filter is a very useful comment to extract the data which satisfy the required criteria. When we program for other users, it is good to...
›
Home
View web version
