|SendEmailUsingThisAccount||Email address(es)||Subject||Body Text|
Tags: .SendUsingAccount, Email by VBA, objOutlook.Session.Accounts
Tags: Array, Convert formulas to values, Evaluate, Excel, formula to values, Like, VBA
Many times i have seen this query on Excel discussion groups and forums to convert values for a specific formulas on worksheets. so i have decided to post a something about that. it might be little helpful for Excel users.
here is a code which will convert formulas to values on every sheets, this code asks formula name which need to be converted in value and then start looking the formulas and where any cells contain that specific formulas (not only that single formula but it can be with in another formula) it will evaluate that formula and will put the value in the cells.
Tags: Array, Dictionary, Exce, Excel VBA Array, Loop, VBA Array
Although VBA is a great language to manipulate office objects accordingly, but when it came to array handling there are lack of method to handle array,
To resolve some of problems i collect and create some method and properties, see the content listed below which you can find in the class module .
Functions available in My Class Module for array handling .
|Function Name||Description||Return Type|
|Function Offset||By This Function You can Extract any Part of an Array.. It works like Excel Offset function||Array Class Object|
|Function FilterArray||as name implies , you can Filter array by this function||Array Class Object|
|Function Sort||You can sort an array . ACS and DESC order||Array Class Object|
|Function IsArrayFilled||you can check weather array is empty or not||True/False|
|Function IsArray2Dimensional||Return True if array is 2 D||True/False|
|Function CombineArray||Most Important Function to Combine Two Array, Either by Rows or Columns||Array Class Object|
|Function Rows||you can Extract a particular Row from an Array||Array Class Object|
|Function Columns||you can Extract a particular Columns from an Array||Array Class Object|
|Function Transpose||Just Using Normal VBA Transpose Function to Transpose Array. Limited as VBA Transpose||Array Class Object|
|Function GetUnique||You can Get Unique Array List by this Function||Array Class Object|
|Function CopyFromRecordset||you can assign an Object input Array from a Recordset||Nothing|
you can find some properties of an Array object’s Listed below :
Tags: Bar Stack Chart, Charts, Chat, Excel, Hierarchy Chart, Stack Chart, VBA
I have customize stack bar chart to a hierarchy chart by using some VBA,
This chart displays the next level data of a selected , user can select a parameter by double click on a series,
you can download .xlsm from here
Note : You can use it with excel 2010.
Thanks for reading