- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 245
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-11
|
¦^´_ 1# metrostar - Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- If Target.Column <> 3 And Target.Column <> 4 Then Exit Sub
- Application.DisplayAlerts = False
- Selection.TextToColumns Destination:=Range("G" & Selection.Row), DataType:=xlFixedWidth, _
- FieldInfo:=Array(Array(0, 1), Array(4, 1), Array(8, 1), Array(12, 1)), _
- TrailingMinusNumbers:=True
- Application.DisplayAlerts = True
- End Sub
½Æ»s¥N½X ¿ý»s¥¨¶°§ï¤@¤U´N¦n¤F
metrostar304.rar (8.75 KB)
|
|