Googleelgoog - googleelgoog.com
General Information:
Latest News:
Multiple Data Connections Refresh Issue via VBA Solved 30 Aug 2012 | 09:10 am
Recently, I had built a Excel Model with 50+ different data connections. Initially I intend to use VBA to refresh all of them in one go, like: ActiveWorkbook.RefreshAll But I quickly found out that th...
How to unshare a data cache between PivotTable reports? 23 Jul 2012 | 06:43 pm
From Office Help Website: By default, PivotTable reports that are based on the same data source — a cell range in a worksheet or a data connection — share a data cache, but you can unshare this data...
Link a chart title or text box to a worksheet cell 8 Jul 2012 | 02:50 pm
To easily update a chart’s title, axis title and label, or a text box, you can link it to a single cell by creating a reference to that worksheet cell. Any changes will be automatically updated. Make...
Convert text to time in Excel ® 22 Apr 2012 | 07:57 pm
In Excel®, time is just a number between 0 = midnight and 0.999999 = 11:59:59 pm. We can use TIME Function to returns the decimal number for a particular time. The decimal number returned by TIME is...
How to Remove all the Custom Styles in Excel by VBA? 9 Mar 2012 | 09:20 pm
Sub RemoveStyle() Dim st As Style Dim x As Integer x = 0 For Each st In ActiveWorkbook.Styles If st.BuiltIn = False Then st.Locked = False st.Delete x = x + 1 End If Next MsgBox (“Removed ”...
Wait Excel calculations to finish 7 Mar 2012 | 11:10 pm
The Excel object model provides the Application.CalculationInterruptKey property to control how if calculation can be interrupted. Application.CalculationInterruptKey = xlAnyKey >>> The calcuation in...
Text Formatting within a Cell 7 Mar 2012 | 10:24 pm
From chandoo.org Posted on March 6th, 2012 in Excel Howtos , Huis , Posts by Hui 1. Apply any text effect to a single character or group of text characters within a cell Select the cell Enter Edi...
Display the sheet name in a cell by Excel Functions and VBA 3 Mar 2012 | 05:31 pm
VBA Function: Function ShName(N As Range) ShName = N.parent.name End Function Excel Functions: =MID(CELL(“filename”,A1),FIND(“]”,CELL(“filename”,A1))+1,31) =MID(CELL(“filename”,A1),SEARCH(“]”,CE...
MROUND function: Rounding to nearest multiple of 5 solved! 2 Mar 2012 | 11:44 pm
=MROUND(A1,5) or =ROUND(A1/5,0)*5 In fact, MROUND can return a number rounded to the desired multiple! MROUND(number, multiple) The MROUND function syntax has the following arguments: Number Re...
CalculateFullRebuild, CalculateFull & Calculate Methods in Excel 16 Feb 2012 | 05:05 pm
1. CalculateFullRebuild: For all open workbooks, forces a full calculation of the data and rebuilds the dependencies. Dependencies are the formulas that depend on other cells. For example, the formu...
