Wednesday, September 22, 2010

Presentations from SharePoint User Group Finland (Sep 8, 2010)

SharePoint User Group Finland published presentation materials from their September 8th meeting. Some examples how SharePoint can be utilized. Read and download the material.

Microsoft Dynamics CRM 2011 on YouTube

CRM Team has opened a YouTube channel for their video material; discussion, promos etc. Check Microsoft Dynamics CRM 2011 videos.

Excel VBA: Does the Cell or Range Have a Formula

Need to quicky check if a cell contains a formula? Use Range's HasFormula property:

Property definition
expression.HasFormula
  • Expression = Range object
  • Returns:
    • True if all cells in range contain a formulss
    • False if none contain formulas
    • Null if some cells contain a formula 
    • Read-only Variant
Use IsNull to check if the result is Null.

Example 1

Scenario
You have a column, where you want the user to have two options:
  1. By default include a formula
  2. Let the user enter a value manually
The formula is updated on Worksheet_Open or a button.

Solution 
' Update only cells with formulas.
'
If ActiveSheet.Cells(Row, Column).HasFormula  Then
    ' Update or refresh your formula here.
End If

Example 2

See MSDN's HasFormula Property page for an example which recalculates the active worksheet if any cell in the currently selected range contains a formula.

Sunday, September 12, 2010

Dynamics CRM 2011 Beta Is Here!

Beta for Dynamics CRM 2011 is now here, go and check it! My beta instance is already running :)