December 2011
Monthly Archive
Monthly Archive
This macro will alternate the alignment of the current selection:
<pre>Public Sub SetAlign()
Dim oCell As Range
For Each oCell In Selection
If oCell.Row Mod 2 = 0 Then
oCell.HorizontalAlignment = xlHAlignLeft
Else
oCell.HorizontalAlignment = xlHAlignRight
End If
Next oCell
End Sub
</pre>
http://windowssecrets.com/forums/showthread.php/17738-Conditional-formatting-alignment-%28Excel-97-SR2%29
foxconn N15235 :
6.3v 1000uF x2
6.3v 3300uF x2
16v 1800uF