right align

how do i right align excel cell values using vbscript

This will right align the selection.

Sub Macro2()
Selection.HorizontalAlignment = xlRight
End Sub

Thanks, satish works fine