Get Version in Silverlight

Plug in version

Environment.Version

XAP file viersion

Assembly assembly = Assembly.GetExecutingAssembly();

if (assembly.FullName != null)

{

string versionPart = assembly.FullName.Split(',')[1];

string version = versionPart.Split('=')[1];

}

Convert Javascript Date to JSON string for .Net DateTime

var offset = new Date().getTimezoneOffset() / 60;

if (offset <= -10)

offset = '+' + Math.abs(offset) + '00';

else if (offset > -10 && offset < 0)

offset = '+0' + Math.abs(offset) + '00';

else if (offset == 0)

offset = '';

else if (offset > 0 && offset < 10)

offset = '-0' + offset + '00';

else if (offset >= 10)

offset = '-' + offset + '00';

var d = '\/Date(' + (new Date().getTime()) + offset + ')\/';

Copy a column in VBA

Sheets("src").Range("A4", Range("A4").End(xlDown)).Copy _

Destination:=Sheets("dest").Range("A2")

src: worksheet name of source

dest: worsheet name of detination

A2: a cell to perform copy

Select a column in VBA

Range("A4", Range("A4").End(xlDown).Selectz

A4 can be replaced with starting cell